Weighted variance consolidation not working

[wigglyrat]

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:

Capture.PNG (6.8 KiB) Viewed 3114 times

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.

[declanr]

Just put a C-Level rule for the % elements e.g.

Code: Select all

['YearDimension':'2016 YTD Difference','MeasureDimension':'Written Commission']=C:
['YearDimension':'2016'] - ['YearDimension':'2015'];

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.

[babytiger]

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

[wigglyrat]

Thank you - this works perfectly.