TM1 Function for Rules, CONSOLIDATEDAVG

​CONSOLIDATEDAVG returns the average value in a consolidation.  

Where can the CONSOLIDATEDAVG function be used?

Rules and TurboIntegrator

What is the CONSOLIDATEDAVG function?

​CONSOLIDATEDAVG returns the average value in a consolidation.  

What is the syntax for CONSOLIDATEDAVG?

ConsolidatedAvg(flag-value, cube-name, element_1, element_2,… );​
Flag-value  1 – Use consolidation weighting. ​
Flag-value 2 – Ignore zero values when computing the minimum value. ​Flag-value 3 – Use consolidation weighting and ignore zero values. ​
cube-name = Cube name. ​
element_1 = Dimension element name. ​
element_2 = Dimension element name.

A demonstration on how to use CONSOLIDATEDAVG

Use ConsolidatedAvg function to calculate average value  in a consolidation and apply it in the rule to populate the Avg_Value measure in the Product Scorecard cube.