12 Replies Latest reply: Nov 21, 2013 6:25 AM by Mina Patel RSS

    How can I incorporate null values as zero in a calculation?

    Mina Patel

      I have a calculation  a- b but sometimes a or be may be null, how can I script this?

      my code looks something like this at the moment:-

       

      join(Temp table)

      Load

      *,
      (
      A) - (B) as Diff;