Share via

STDEV (Report Builder 1.0)

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.