TM1 Rule - Mixing And Or in a If Statement
Posted: Fri Sep 01, 2017 3:52 pm
Hi,
I made myself into some trouble when using and mixing multiple & (AND) and % (OR) in a If condition.
Let me explain:
Condition A: Change Type
Condition B: Year
If (
A = Inflation
&
B = 2018
%
B = 2019
,1%
,STET)
I meant to put 1% in 2018+Inflation and 2019+Inflation then nothing for the rest.
I realize that the way I put the rule is confusing the years. And I have to split it into 2 rules.
I wonder whether there's a way to tie it in one rule without using multiple If.
Kenneth
I made myself into some trouble when using and mixing multiple & (AND) and % (OR) in a If condition.
Let me explain:
Condition A: Change Type
Condition B: Year
If (
A = Inflation
&
B = 2018
%
B = 2019
,1%
,STET)
I meant to put 1% in 2018+Inflation and 2019+Inflation then nothing for the rest.
I realize that the way I put the rule is confusing the years. And I have to split it into 2 rules.
I wonder whether there's a way to tie it in one rule without using multiple If.
Kenneth