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].[S] as
STDEVP([Customer].[Geography].[Country],
[Measures].[Internet Order Quanlity])
select [Measures].[S] on 0,
subset([Customer].[Geography].[Country],2,7) on 1
from [AdventureWorksMF]