Zn
The function Zn returns the argument 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 be checked.
The argument must be a Number data type.
The function can analyze one argument at a time.
Example
Zn(3)
- Returns 3
Zn(Null)
- Returns 0
Zn([Quantity])
- Returns 0 for every row in the column that is Null.