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 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: 
Coalesce([column_name], ...)
Returns: AnyColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
column_namecolumn✓ YesThe number, date, string, column, or function to be evaluated.
additional argumentsvariadic✗ NoAdditional arguments to be evaluated. All arguments must be of the same data type.

​
Validation

  • Minimum parameters: 1
  • Maximum parameters: Unlimited

​
Examples

Coalesce(Null, 1/0, 1/1, 1/2)
Returns the third argument (1) as it is the first non-Null value. Result: 1 
Coalesce([Sales], 0)
Converts all the Null values in Sales to 0. 
Coalesce([Product Type], [Product Family], [Sku Number])
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 13, 2026