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

    null in fields used in set analisys

    DANIEL CHOTZEN

      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?

      thanks

      Daniel