Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

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

NameTypeRequiredDescription
argumentcolumn|any✓ YesAny 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 13, 2026