$value
$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”.
See Also