IFNULLUSE
Syntax
IFNULLUSE (expression, replacement)
Description
IFNULLUSE checks to see if the value in expression is Null and returns the appropriate expression based on the result.
Arguments
| expression | Any valid expression or a Null value. |
| replacement | The value to return if expression is Null. |
Returns
If expression is not Null, returns the value in expression.
If expression is Null, returns the value in replacement.
Example
The following formula checks to see if the value for MyEntity.LastName is Null, and if so, provides a default value:
IFNULLUSE(MyEntity.LastName, "MissingLastName")
Returns:
— The value in LastName.
— "MissingLastName", if the value in LastName is Null.