STDEV (Report Builder)
Returns the standard deviation of non-null values in a set.
Syntax
STDEV(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 value (the mean).
- This function assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the standard deviation using STDEVP.
- The standard deviation is calculated using the "unbiased" or "n-1" method.
- Logical values such as TRUE and FALSE and text are ignored.
Examples
| Formula | Result |
|---|---|
STDEV(Sum Total Due) |
Returns the standard deviation for the sum total sales due. The value returned is displayed similar to the following: 3843.30754081202. |
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)