STDEVP (Report Builder)
Returns the standard deviation of non-null values based on the entire population given as arguments.
Syntax
STDEVP(aggregate)
aggregate |
Specifies the field name or formula to aggregate. |
Remarks
- The standard deviation is a measure of how widely values are dispersed from the average (the mean).
- Text and logical values such as TRUE or FALSE are ignored.
- STDEVP assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the standard deviation using STDEV.
- For large sample sizes, STDEV and STDEVP return approximately equal values.
- The standard deviation is calculated using the "biased" or "n" method.
Examples
| Formula | Result |
|---|---|
STDEVP(Sum Total Due) |
Returns the standard deviation for total sales due. The value returned is displayed similar to the following: 3843/-2671018501. |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Aggregate Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Data, Text, and Images (Report Builder)