TM1 Function for Rules,​ IF

IF is a logical expression function which allows to evaluate multiple logical expression.

Where can the IF function be used?

Rules and TurboIntegrator

Which TM1 Server version is this function available for?

Version 11 and 12

What is the IF function?

IF is a logical expression function which allows to evaluate multiple logical expression. 

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

A demonstration on how to use IF

Use IF function to evaluate the logical expression and apply it in the rule to populate the Commission measure in the Product Scorecard cube.