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, refer to 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, refer to Conditional Examples here.
For a scenario using the IF function, refer to Comparing Localized Values Scenario here.
For a scenario using the IF function, refer to Product Description Scenario here.
For a scenario using the IF function, refer to New Product Indicator Scenario here.
For a scenario using the IF function, refer to Identifying Child Objects Scenario here.