TM1 Forum

Hi All,

I need some advice on where I am going wrong with a re-write of an existing rule.

The current rule references the 'Amount' measure & works just fine.
The issue is the client does not want to mix a rate with the 'normal' dollar amounts as you cannot sum these together logically.

My solution was to create a new measure called 'Rates' & reference the rule to this new as below;
Well it doesn't work, I'm getting a 0 value returned. I'm lost on where I am going wrong, sorry if its bleeding obvious, I'm a newbie to Tm1.

The Contribution Margin is a C element made up of 3 N elements.

The Contribution Margin rate is a C element, but I did this to avoid writing feeders , i.e. I added a feeder as a child; "tonnes despatched''.

I'm using 9.5.2, 64bit, Win7, excel 2010

Any advice would be very appreciated.
Thanks,
Maznik



I am using 9.5.2, 64bit, Win7

Maznik wrote:Well it doesn't work, I'm getting a 0 value returned.

That's because of this little snippet of code
In your case it's always going to find a zero and thus not work. When you use the shorthand notation (using the []) then it means use the corresponding elements from the left hand side. In your case that would be 'Rates' from the measure dimension, not 'Amount'. You need to specifically spell out 'Amount' in your IF statement.

Thankyou very much Tomok, you saved me from going just a little bit more insane