Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the standard deviation of non-null values based on the entire population given as arguments.
STDEVP(aggregate)
aggregate |
Specifies the field name or formula to aggregate. |
- 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.
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. |
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)