Variance of a sample

Returns the variance based on a sample of a population. Variance is a measure of how spread out a set of values is. It is calculated as the average squared deviation of each number from its mean. This is a group-value function.

Syntax

Var<Distinct = False, FactID>(Argument)

• Distinct is a true/false parameter that allows you to calculate using all values in the list or only the unique values.

• 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.