MicroStrategy Functions Reference
© 2011 MicroStrategy, Inc.
• FactID is a parameter that forces a calculation to take place on a fact
table that contains the selected fact.
This function returns an error if a value in the value list is negative.
Suppose you have an investment that earns 10% the first year, 60% the
second year, and 20% the third year, and you want to answer the question
“What is its average rate of return?” You do not want to use the Avg function
to obtain the arithmetic mean, because these numbers show that in the first
year your investment was multiplied by 1.10, in the second year by 1.60, and
in the third year by 1.20. The average is the geometric mean of these three
numbers. This can be understood as looking for a constant that you can
multiply each year’s investment by, and get the same result as multiplying
the first year by 1.10, the second year by 1.60, and so forth. This constant is
the geometric mean.
(1.10 * 1.60 * 1.20)
The geometric mean is 1.283, so the average rate of return is about 28%.
Returns the larger of two or more values. The Greatest function differs
from the Max function, which returns the largest value in a single value list.
Greatest can take multiple lists as input and compare the elements in the
lists. It is used for comparisons between metrics.
Greatest(Argument1, Argument2,..., ArgumentN)
The arguments must be metrics.