Rule Help
Posted: Fri Oct 18, 2013 11:07 am
Hello,
I am newbie to TM1 development. I have came across and issue that needs a solution. As you can see.
I want to calculate for all Phases in dimension in the following way
For Phase-10001000
Spend-Overheads (Allocated HO by RO) = 50 (In percentage)
So,
How to make this code dynamic so that it will apply to all phases of all projects, instead me hardcoding each and every phase.
In future they may add new phases so the code should work without adding a new code to the rule.
I am newbie to TM1 development. I have came across and issue that needs a solution. As you can see.
I want to calculate for all Phases in dimension in the following way
For Phase-10001000
Spend-Overheads (Allocated HO by RO) = 50 (In percentage)
So,
Code: Select all
['Phase-10001000','Spend-Overheads (Allcoated) in Crs'] = ['Project-1000', 'Spend-Overheads (Allocated HO by RO)'] * ['Phase-10001000', 'Spend-Overheads (Allocated HO by RO)'] / 100;
i.e 4.1 * 50 / 100 = 2.05
In future they may add new phases so the code should work without adding a new code to the rule.