Conditional Functions
Calculated Attribute expressions can be written using the following available functions. Use Cases follow the available functions table.
|
Conditional Function |
Parameters |
Description |
|---|---|---|
|
AND |
(condition1, condition2, ...) |
Returns 1 (=TRUE), if all the supplied conditions are true; otherwise returns 0 (=FALSE). |
|
IF |
(condition, 'value_if_true', 'value_if_false') |
If 'condition' is true, then 'value_if_TRUE' is returned, otherwise 'value_if_FALSE' is returned. The OR, AND, and NOT functions can be used with the IF function to check multiple conditions at a time. For more information, these are explained in the Other Functions documentation here. The EXACT function can be used with the IF function to verify if two strings match exactly. For more information, see the Text Functions documentation here. |
|
NOT |
(condition) |
Returns 1 (=TRUE) if condition is false; otherwise returns 0 (=FALSE). |
|
OR |
(condition1, condition2, ...) |
Returns 1 (=TRUE) if one of the supplied conditions is true; otherwise returns 0 (=FALSE). |
Use Cases
For examples of these functions, see Conditional Examples here.
For a scenario using the IF function, see Comparing Localized Values Scenario here.
For a scenario using the IF function, see Product Description Scenario here.
For a scenario using the IF function, see New Product Indicator Scenario here.
For a scenario using the IF function, see Identifying Child Objects Scenario here.