TM1 Forum

Hi All,

I have used the consolidated Avg function in a rule to get the average on Percentages. Below is the sample rule:
Rule:

SKIPCHECK;

['No Week','Sample %1'] = ConsolidatedAvg(1,'Cube Name', !Dim1, !Dim2,!Dim3,... ,'All Weeks','Sample %1');

['No Week','Sample %1 Oversteer'] = ConsolidatedAvg(1,'Cube Name', !Dim1, !Dim2,!Dim3,... ,'All Weeks','Sample %1 Oversteer');


FEEDERS;

['All Weeks','Sample %1']=>['No Week','Sample %1'];

['All Weeks','Sample %1 Oversteer']=>['No Week','Sample %1 Oversteer'];

Where All weeks is a dimension element which contains elements like Week1, week2... and so on upto Week 53.

Sample %1 and Sample %1 oversteer are rule calculated measures on Week1, Week2,.. Week 53.

I have attached a print screen of the data on these measures by week, as you can see the data is same across these measures, but the calculated average on No Week different.
The Average value calculated on Sample %1 is correct but on Sample %1 oversteer isn't correct and Im not able to find a reason why its calculated in correctly. Could you please help me on this?

Please let me know if you need more details.

Thanks in advance!

Hi,

Why do yo need to push ConsolidatedAvg into a new value of a No week, when you can just have an All Weeks Average Consolidation ( or whatever you want to call it ) and simple a rule like this:

['All Weeks Average'] = C: ConsolidatedAvg(1,'Cube Name', !Dim1, !Dim2,!Dim3,...

Or no rule at all:

All Weeks Average Consolidation
- 01 ( Weight 1/52 )
- 02 ( Weight 1/52 )
and so on ....

Regards,

ET