7 Replies Latest reply on Jul 3, 2018 1:02 AM by Haan Haan

    Null as 0

    Haan Haan

      Hi all

      Referring to the sales cal and variance calculation field....may i know how to amend it if wanted the null to become 0?

      for the sales cal i am able to do it as below...but the variance i cant

      ZN(lookup(sum(IF [Date] = [DateLbl] THEN [Sales] END),0))

       

      May i know how to do it?