Consolidation calculation rules functions

The ConsolidatedMax; ConsolidatedMin; ConsolidatedAvg; ConsolidatedCount; and Consolidated CountUnique perform mathematical calculations on consolidations.

ConsolidatedAvg
ConsolidatedAvg calculates the average value in a consolidation and returns that single value.
ConsolidateChildren
ConsolidateChildren forces consolidated values to be calculated by summing immediate children along a specified dimension. ConsolidateChildren is useful when intermediate consolidations are calculated by rules and you want a parent consolidation to be calculated by summing the intermediate consolidations rather than by summing the underlying leaf values.
ConsolidatedCount
ConsolidatedCount returns the number of values in a consolidation.
ConsolidatedCountUnique
ConsolidatedCountUnique counts the number of unique elements for which data points actually exist for the specified consolidation. The unique elements are counted along one dimension of the consolidated cell.
ConsolidatedMax
ConsolidatedMax calculates the maximum value in a consolidation and returns that single value.
ConsolidatedMin
ConsolidatedMin calculates the minimum value in a consolidation and returns that single value.

Parent topic: Rules functions