Function: ZeroIfNull
Description
ZeroIfNull evaluates a field value or the result of an expression and returns 0.0 if value is null. Otherwise it returns the value of the field or expression.
This function only applies to numeric fields or expressions that return a numeric value.
Syntax
ZeroIfNull(expression)
Arguments
Expression is any numeric field value or regular expression that returns a numeric value.
Return value
This function returns the following:
-
0.0 if the argument is null.
-
<actual value> if the argument is not null
Calculated field example
To determine if an Amount field has null values, or to force null Amount values to have a value of 0, use the expression: ZeroIfNull(Amount)
© 2024 Altair Engineering Inc. All Rights Reserved.