IF Rules function for IBM Planning Analytics (TM1)
IF is a logical expression function that evaluates multiple logical expressions.
In this video, IF will be used to evaluate the logical expression and apply it in the rule to populate the Commission measure in the Product Scorecard cube.
Where can the IF function be used?
Rules and TurboIntegrator
Which TM1 Server version is the IF function available for?
Version 11 and 12
What is the syntax for IF?
IF (expression, True_Value, False_Value)
- Expression = logical expression to evaluate if it is true or false
- True_Value = Value when the expression is true
- False_Value = Value when the expression is false