Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

Var (MDX)

Returns the sample variance of a numeric expression evaluated over a set, using the unbiased population formula (dividing by n).


          

Var(Set_Expression [ ,Numeric_Expression ] )
        

Set_Expression

A valid Multidimensional Expressions (MDX) expression that returns a set.

Numeric_Expression

A valid numeric expression that is typically a Multidimensional Expressions (MDX) expression of cell coordinates that return a number.

The Var function returns the unbiased variance of a specified numeric expression evaluated over a specified set.

The Var function uses the unbiased population formula, and the VarP function uses the biased population formula.

Community Additions

ADD
Show:
© 2014 Microsoft