TM1 Forum

Hi:

For a report users require a variance calculation between different years, for example, 2016 and 2015. For this a consolidated element has been created called '2016 YTD Difference' which includes element 2016 with a weight of 1 and 2015 as a weight of -1. This calculation works fine, except when it comes to percentages, for example:
I understand that this does not work at a consolidated level. How would I get the above in 'Written Commission %' '2016 YTD Difference' '3 LTD' to give me (1.41%)?

Many thanks for your assistance in advance.

Just put a C-Level rule for the % elements e.g.
You can of course expand the basic concept to include all of your various percentage elements and year combos.

EDIT - Make sure to consider the placement in relation to other rule statements you have; keeping statement precedence in mind.

And another Edit for of/off typo.

I would prefer to apply ConsolidateChildren to the year dimension, such as:
['YearDimension':'2016 YTD Difference','MeasureDimension':'Written Commission']=C:
ConsolidateChildren('YearDimension');

Thank you - this works perfectly.