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

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