Function IIF
Allows a condition to be checked with branching output
IIF([CHECK_VALUE],[VALUE_TRUE],[VALUE_FALSE])
Parameters
# | Type | Passing | Default | Name | Description/Comments |
---|---|---|---|---|---|
1 | boolean | required | n/a | CHECK_VALUE | The condition to check |
2 | any | required | n/a | VALUE_TRUE | A value to return if parameter 1 is true |
3 | any | required | n/a | VALUE_FALSE | A value to return if parameter 1 is false |
Returns
The parameter 2 if parameter 1 is true otherwise parameter 3
Examples
Example of conditional expression
{{IIF(IsValid(CLCODET),"Tenant Found","Tenant Not Found")}}