The STDEVS aggregation function returns the sample standard deviation of a given line item.
This function can be useful for analyzing sample customer feedback variability or sample sales rep deal size variation.
Syntax
Source[STDEVS: Mapping, STDEVS: Mapping 2, etc.]
Arguments
| Argument | Data type | Description |
| Source | Number | The values to return the sample standard deviation of. |
| Mapping | Date, time period, list | The mapping that determines which values to return the sample standard deviation of. This argument can be repeated to provide multiple mappings. |
The STDEVS aggregation function returns a numeric result.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
'Recent Feedback'.'Feedback Score'[STDEVS: 'Product Assignment'.'Product Type']
Additional information
- The population variance of a single value is zero.
- The population variance of a set of values, which includes NaN, is NaN.
- The square of STDEVS is equal to VARS. See Related Anaplan functions, below.
Constraints
- You can't use STDEVS with another number-typed aggregation function.
- STDEVS returns zero for unmapped points.
- You can't use STDEVS together with the Formula summary method.
- You can't use STDEVS in version formulas.
Excel equivalent
Examples
Example 1: Analyze sample customer feedback variability
Example 2: Analyze sample sales rep deal size variation
