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.