IfNull

Description

Returns the user-specified alternate value when an expression is NULL.

Input arguments

Argument Name	Data Type		Description
<expression>	String		First argument: the expression to be evaluated for NULL
	DateTime
	Decimal
	Integer
	Real
<expression>	String		Second argument: the expression for which the value will be returned if the first argument is NULL
	DateTime
	Decimal
	Integer
	Real

Return type

Auto-typed (same as input type)

Example

Explanation

Return the value zero (0) if Field1 is NULL; otherwise, return the value of Field1.

Configuration

Result