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.