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 Other Functions. The EXACT function can be used with the IF function to verify if two strings match exactly. For more information, refer to Text Functions. |
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 Functions.
For a scenario using the IF function, refer to Comparing STEP and Excel Functions.
For a scenario using the IF function, refer to Product Description Scenario in the System Setup documentation.
For a scenario using the IF function, refer to New Product Indicator Scenario in the System Setup documentation.
For a scenario using the IF function, refer to Identifying Child Objects Scenario in the System Setup documentation.