Returns the argument if it is not null, otherwise returns zero.
This function is helpful if you want to use zero values instead of null values.
Usage
Zn(argument)
argument (required) The number value to be checked.
Examples
(1) Returns 3.
Zn(3)
(2) Returns 0.
Zn(null)
(3) Returns 0 for every row in the column that is null.
Null([Quantity])
Related Functions
Coalesce - Returns the first non-null value from the arguments provided.
IsNull - Returns True if the argument is null. Otherwise returns False.
IsNotNull - Returns True if the is NOT null. Otherwise returns False.