Good afternoon,
Can someone help me with the following question?
If any of the values under code:02,code:03, code04 is blank my calculation do not work, how can I replace what I believe are empties not nulls for a 0 (zero)?
SQL query:
(FILTER ("Account Revenue"."Sales Revenue USD" USING ("Account Revenue"."Cd" ='04'))-FILTER ("Account Revenue"."Sales Revenue USD" USING ("ESP"."Account Revenue"."Cd" ='03')))
