if there are nulls in my columns, I need to add a new column 'Note' which says no data.

[poornimak]

Hi

 Can someone help creating a new columns if my data say

[Field4], [Field5],[[Field6] are [Nulls], then I need to create a new column with a remark/note to mention that data is not available.

[binuacs · Accepted solution]

@poornimak If all three columns should be null to display the message then you can write the below formula in the formula tool

IIF (IsNull([Field4]) AND IsNull( [Field5]) AND ISNull([Field6]),'Data is not available',Null())

If any one of the fields is Null then use the OR instead of AND in the above formula 

[ShankerV · Accepted solution]

Hi @poornimak 

Please use the formula tool, 

In the Configuration Pane, Select Add Column and Type your name of the new desired column.

Then use the below formula, 

IF IsEmpty([Field4]) AND IsEmpty([Field5]) AND ISEmpty([Field6])
THEN "Data is not available"
ELSE Null()
ENDIF

Many thanks

Shanker V