8 Replies Latest reply on Apr 10, 2018 3:29 PM by Peter Fakan

    Trying to calculate the number of occurrences of a particular value from data source but becomes NULL when the particular field has no data. How to make it 0?

    Ee King Beh

      Below is the calculated field that I'm trying to use.


      IF ISNULL(SUM(INT([Staff State]="ACD" OR [Staff State]="ONHOLD"))) THEN 0 ELSE SUM(INT([Staff State]="ACD" OR [Staff State]="ONHOLD")) END