Is Null vs Is Empty

[keithr197]

Hi 

Im currently looking at a dataset where column A has data (including blank cells) 

I need to add a new column to identify the blank records.

The above is an example of column A, if column A = Null then [N] else [Y]

I used the following formula, however receiving an error: If ([LIS RRS]<=1 then [Y] else [N] endif)

Thanks for the assistance

[Maskell_Rascal · Accepted solution]

Hi @keithr197 

So IsEmpty does the same thing as IsNull with the added benefit of finding blank values ""

Regarding your formula, you are using two different structures for writing an IF statement. If you are trying to write a formula to identify the empty values, you can use one of the below. 

IIF(IsEmpty([LIS RRS]), 'N', 'Y')

OR

IF IsEmpty([LIS RRS]) THEN 'N' ELSE 'Y' ENDIF

If this solves your issue please mark the answer as correct, if not le me know!

Thanks!

Phil

[Qiu]

@keithr197 
We can modify your original formula to make it work. 😁

[keithr197]

Thanks this seems to help👌