MicroStrategy ONE

Geometric Mean

Returns the Geometric mean of a range of positive values. Use this function to find the average for a set of values contributing to a product. Use the Avg (Average) function to find the average (arithmetic mean) for a set of values contributing to a sum. This function can be used to determine, the average growth rate for a given compound interest with variable rates. This is a group-value function.

Syntax

GeoMean<FactID>(Argument)

  •  

  • FactID is a parameter that forces a calculation to take place on a specific fact table containing the FactID.

  • Argument is an attribute, fact, or metric representing a list of numbers.

For additional information on and an example of this function, refer to the Functions Reference.