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

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