Skip to main content

ISNOTNULL

Checks to see if a value is not null. If the value is null it will return false otherwise true will be returned.

Generally used within IF statements or filter functions.

Syntax​

bool ISNOTNULL(object value)

Example​

The example below uses ISNOTNULL within an IF function to return Value2 if the value is MyColumn is not null. Otherwise NULL is returned if the value in MyColumn is null.

IF(ISNOTNULL(MyColumn), "Value2", NULL())