TM1 Forum

Posted: **Thu Jul 21, 2011 10:42 am**

Hello,
Will IF(OR(condition1,condition2),true,false) or IF(OR(condition1,condition2),true,false) work in rules?

Posted: **Thu Jul 21, 2011 10:54 am**

telula wrote:Hello,
Will IF(OR(condition1,condition2),true,false) or IF(OR(condition1,condition2),true,false) work in rules?

Sure. If the "rules" are for Excel.

In TM1, however, the syntax is different. Refer to the Rules Guide, specifically the heading "Components of a Rule "

Using Logical Operators

You can combine expressions in a calculation statement using logical operators.

Operator: & (ampersand)
Meaning: AND
Example: (Value1 > 5) & (Value1 < 10)
Returns TRUE if the value is greater than 5 and less than 10.

Operator: % (percentage sign)
Meaning: OR
Example: (Value1 > 10) % (Value1 < 5)
Returns TRUE if the value is greater than 10 or less than 5.

Operator: ~ (tilde)
Meaning: NOT
Example: ~(Value1 > 5)
Equivalent to (Value1 <= 5)

TM1 Forum

IF( AND( ),true,false) in rules

IF( AND( ),true,false) in rules

Re: IF( AND( ),true,false) in rules