Reference existing Rule to a new measure does not work.

[Maznik]

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.

Rule1.PNG (8.47 KiB) Viewed 1190 times

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;

Rule2.PNG (9.77 KiB) Viewed 1190 times

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.

Cube.PNG (16.98 KiB) Viewed 1190 times

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

[tomok]

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

That's because of this little snippet of code

Code: Select all

IF(['Tonnes Despatched'] = 0,

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.

[Maznik]

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