ConsolidatedAvg function

[EvgenyT]

Hello Guys,

I have recently came across a need to calculate averages at C: levels and I thought to myself ConsolidatedAvg should do a trick.... with the following formula:
['LTI Average'] = C:ConsolidatedAvg(2,'',!Period,!Industry,'LTI Average');

Here are my findings:


As you can see from the example below, Value of 12.42 as an average of 8.13 and 16.7 is correct (24.83 / 2 = 12.415 not rounded)

Untitled.png (8.07 KiB) Viewed 2404 times

But if you go a level up, for example at All Industries level, the sum of 132.94 all divisions / 17 (I am ignoring blank intersections) should give you 7.82, but the result I am getting is 8.11

Untitled2.png (12.87 KiB) Viewed 2399 times

Is this function not performing correctly or am I missing something here? TM1 vers. 10.1.1

Look forward to your inputs

Thank you

ET

[EvgenyT]

Hello Again Guys,

I have just answered my own question, function works slightly different to what I expected...

top level consolidates average amongst n-level elements rather than immediate children.... guess I have to find a work around