MicroStrategy ONE
Average
Returns the average (also known as arithmetic mean) of two or more values. Average is the sum of a set of values divided by the number of values.
The Average function differs from the Avg function, which returns the average of values in a single value list. The Average function can take multiple metrics as input and average the corresponding 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, Argument3,…, ArgumentN)
Where
The arguments must be metrics or constants.