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)