Consolidated Average (CAVERAGE)

Purpose

This function calculates the average value in a consolidation and returns a single value.

This function is available on the Aggregation tab of the Expression Editor when you are working with a cube calculation or with a C calculation in a dimension.

Parameters

The flag-value parameter can be one of the following values:

• 1 - Do not use consolidation weighting to compute the value. If this flag is turned on, the raw value of the consolidated element is used.
• 2 - Ignore zero values. If this flag is set, zero values are not used as part of computing an average.
• 3 - Combination of the flag value 1 and 2; do not use consolidation weighting to compute the value and ignore zero values.

Sample

For example, this function is used by the default metric indicator named Tolerance.

=CAVERAGE(3)