MicroStrategy ONE

Average

Average performs a sum of a set of values and divides this total by the number of values in the set. This returns the average (also known as arithmetic mean) for the set of values.

The Average function differs from the Avg function (see Avg (Average)), which returns the average of values in a single value list. The Average function can take multiple metrics as inputs and average the values of the metrics. You can use this function to compute and display the average of two or more metrics on a report.

Syntax

Average(Argument1, Argument2,..., ArgumentN)

Where:

The arguments must be metrics or constants.