4 Replies Latest reply: Dec 29, 2015 7:34 AM by Stefan Wühl RSS

    null in fields used in set analisys


      i have a field "Status"

      i want to sum all sales where Status = 'Approved'


      i use this


      sum( {<Status={'Approved'}>}  Sales).


      this works as axpected.

      my problem is when i have only null() values in the Field Status.


      in that case i would have like the expression above to return 0 (zero) or at least null

      instead it just give me the sum of all sales regardless of whats in the Status Field (EG just all the sales)


      how can i tell it to work as i need?