Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
The expression will work no matter what format you will use
That is basicly the same thing, so do not get cought with reviewing expressions - they both ok.
regards
Lech
It was a typo. I have used it correctly.