nvl

First determines if the value of the first parameter is null. If it is, it returns the value of the second parameter.

Syntax

nvl(expr1, expr2)

Enabled for

Parameters

Return Value

Text value:

• Returns the value of expr2 if the value of expr1 is null.
• Returns the value of expr1 if the value of expr1 is not null.
• Returns "" if the values of both expr1 and expr2 are null.

Example

The following example tests the Owner field to see if it is empty, and returns the appropriate message:

$(if(

(nvl("Owner", "") !=""),

"Owner is not null or empty",

"Owner is null or empty"

))