Calculated Attribute expressions can be written using the following available functions. Examples follow the Available Functions table.
Available Functions
|
Conditional Function |
Parameters |
Description |
|---|---|---|
|
IF |
(condition, 'value_if_true', 'value_if_false') |
If 'condition' is true, then 'value_if_TRUE' is returned, otherwise 'value_if_FALSE' is returned. |
Note: The OR(), AND(), and NOT() functions can be used with IF function to check multiple conditions at a time. For more information, these are explained in the Other Functions documentation here.
Examples
Copy and paste any of the following examples into the Function Editor and then evaluate to get the defined result.
if (1=1, 'true', 'false') // = "true"if (not(1=1), 'true', 'false') // = "false"if (exact('hello','you'), 'true', 'false') // = "false"if (or(1=1,exact('hello','you')), 'true', 'false') // = "true"if (and(1=1,exact('hello','you')), 'true', 'false') // = "false"
2017, Stibo Systems