IF Rules function for IBM Planning Analytics (TM1)

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

Relevant Functions

• CONTINUE = Allows a subsequent rule within the same intersection to be executed
• IF = Uses a conditional expression to check if an expression is true or false
• STET = Cancels the effect of the rule for a specified element