TM1 Function for Rules, CONSOLIDATEDAVG
CONSOLIDATEDAVG returns the average value in a consolidation.
Where can the CONSOLIDATEDAVG function be used?
Rules and TurboIntegrator
Which TM1 Server version is this function available for?
Version 11 and 12
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.