11 Replies Latest reply: Feb 3, 2017 10:48 AM by Prasanna Chandran RSS

    IsNull Function

    Prasanna Chandran

      The chart that I have generated is displayed as follows. This is as a result of association where there was no value for this field against the customer number originating from another source.

       

      I understand that if I apply IsNull function to it, these records should return true.

      Example. I have derived a new field in chart with expression:

      If(IsNull[Reporting Date], 'Yes,'No')       //* Ignore the field name in expression to chart shown *//

       

      When I apply this, I get 'No' correctly wherever Reporting Date had valid values. But I am not getting a 'Yes' where Reporting Date was displaying as ' - '.  Instead I get the same value '-' displayed in derived field.  Could you please help me with this or explain why is this happening?