##### CONSOLIDATEDCOUNT returns the number of values in a consolidation.

**Where can the CONSOLIDATEDCOUNT****function be used?**Rules and TurboIntegrator

**What is the CONSOLIDATEDCOUNT****function?**CONSOLIDATEDCOUNT returns the number of values in a consolidation.

**What is the syntax for CONSOLIDATEDCOUNT?**ConsolidatedCount(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.

**CONSOLIDATEDCOUNT****A demonstration on how to use**Use ConsolidatedCount function to count the number of values in the consolidation and apply it in the rule to populate the Avg_Value element in the Product Scorecard cube.

##### See how Cubewise can help you

We would love to show you how a set of applications could help you forecast, budget and plan better.

Book