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())