$value
Welcome to our Knowledge Base
Documentation | Blog | Demos | Support
< All Topics
Print
$value
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
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
Updated
ByJason Lee
Was this article helpful?
5 out of 5 stars
1 rating
5 Stars | 100% | |
4 Stars | 0% | |
3 Stars | 0% | |
2 Stars | 0% | |
1 Stars | 0% |
5