VarP (MDX)

Returns the Variance, dividing by n-1

numeric-value

Returns the sample variance dividing by n-1 (Wikipedia).

Returns the sample variance. Note that empty members are ignored.

Query

Ceiling(VarP( [Geography].[Geo].[Country].members, [Amount] ),4)

Result

97432.0

Assertion : MDX Equals

Ceiling(VarP( nonempty([Geography].[Geo].[Country],[Amount]), [Amount] ),4)

Assertion : MDX Equals

Ceiling( StdevP([Geography].[Geo].[Country],[Amount]) * StdevP([Geography].[Geo].[Country],[Amount]), 4)

Find here the value of the XMLA properties when not specified otherwise.