STDEVP
Description:
This functions returns the population standard deviation of a numeric expression evaluated over a set, using the biased population formula (dividing by n).
Syntax:
STDEVP(Set_Expression [ ,Scalar_Expression ] )
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Set_Expression | It is a valid MDX expression that returns a set. |
Scalar_Expression | It is a valid Scalar expression that is typically a MDX expression of cell coordinates that return a scalar value. |
Example:
WITH MEMBER [Measures].[Sales StdDev] AS
STDEVP([Product].[Product].[Product].Members, [Measures].[Internet Sales Amount])
MEMBER [Measures].[Sales Variance] AS
POWER([Measures].[Sales StdDev], 2)
MEMBER [Measures].[Coefficient of Variation] AS
[Measures].[Sales StdDev] /
AVG([Product].[Product].[Product].Members, [Measures].[Internet Sales Amount]),
FORMAT_STRING = 'Percent'
SELECT {[Measures].[Sales StdDev], [Measures].[Sales Variance], [Measures].[Coefficient of Variation]} ON
COLUMNS
FROM [AdventureWorksMF_ValueBased]