Provides a default value for an expression that can be $Null.

Syntax

$value(expression1,expression2)

Parameters

Return Value

Same as the selected expression.

Comments

If expression1 is not $Null, $value returns the value of expression1; otherwise, it returns the value of expression2.

Example

detail line "Employee Number: " $value(EmpNum,"N/A")

Traps $Null values in a report and replaces them with “N/A”.

See Also

About Functional Expressions

CASE

Expressions and the $Null Property

IS [NOT] [$]NULL