ConsolidatedAvg function
Posted: Tue Oct 22, 2013 3:25 am
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)
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
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
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 2407 times
- Untitled2.png (12.87 KiB) Viewed 2402 times
Look forward to your inputs
Thank you
ET
