Zn
Zn
The Zn function returns the argument value if it is not Null, otherwise returns zero. Zn allows the convenient use of zero values in place of Null values.
Syntax
Zn(argument)
argument (required) The number value to check.
The Zn function can analyze one argument at a time.
Example
- Returns 3
- Returns 0
![Sigma formula editor with Zn([Quantity]) entered and the Quantity (without nulls) column showing 0 where Quantity is null.](https://fdr-prod-docs-files-public.s3.us-east-1.amazonaws.com/sigma.docs.buildwithfern.com/8901b865c0209c6e7dcb276669951fffa8c1048593098fa979bb7bad28cf4554/assets/docs-images/4b310ba-jk.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=AKIA6KXJSKKNFOCF7G4B%2F20261005%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20261005T214746Z&X-Amz-Expires=604800&X-Amz-Signature=96dcd7279a7fc6cc3a243a8f7c44b56fe17ace66b4e513ff453605bbc873cf4e&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)
- Returns 0 for every row in the column that is Null.