IsNull - Anlytic

Returns True if the argument contains missing data values, and False if the argument is not Null. Often applied to a column of data to test for Null values. Category: logical Syntax:

IsNull(argument)

Returns: BooleanColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`argument`	`column\|any`	✓ Yes	Any argument can be provided. The function can analyze one argument at a time.

Validation

Minimum parameters: 1
Maximum parameters: 1

Examples

IsNull([Sales])

Returns False for rows where sales data exists and True for rows where there is no data.

IsNull([prm-date-range].start) and IsNull([prm-date-range].end)

Returns True when no start and end date is provided in a Date Range parameter.

Last modified on March 6, 2026