Skip to main content
Returns the value of the first argument that is not Null. Often applied to columns to check for Null values and assign placeholder values in replacement of Nulls. Category: logical Syntax:
Returns: AnyColumn Context Filtering: ✓ Yes

​
Parameters

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: Unlimited

​
Examples

Returns the third argument (1) as it is the first non-Null value. Result: 1
Converts all the Null values in Sales to 0.
Return Product Type if it exists; return Product Family if there is no Product Type. If both don’t exist, return SKU Number.
  • IsNull - Check if a value is null
  • Zn - Convert nulls to zero specifically
  • If - Conditional logic for more complex null handling
Last modified on March 6, 2026