$value

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

Syntax

$value(expression1,expression2)

Parameters

expression1

any expression

expression2

any expression

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".

 

Related Topics