Zn - Anlytic

Returns non-Null values, or 0 (zero) instead of Null values. Category: logical Syntax:

Zn([value_column])

Returns: NumberColumn Context Filtering: ✓ Yes

Parameters

Name	Type	Required	Description
`value_column`	`number\|column`	✓ Yes	The value or column to evaluate. Null values are converted to 0.

Allowed Column Types: INT, FLOAT, DECIMAL

Zn([Sales])

Returns sales values as-is, but converts Null values to 0.