VAR (Report Builder 1.0)

Returns the variance of non-null values in a set.

Syntax

VAR(aggregate)

aggregate

Specifies the field name or expression to aggregate.

Remarks

• VAR assumes that its arguments are a sample of the population. If your data represents the entire population, then compute the variance using VARP.

• Logical values such as TRUE, FALSE, and text are ignored.

Examples

Formula	Result
VAR(Sum Total Due)	Returns the variance of the Sum Total Due. The value returned is similar to the following: 14771012.8532626.

See Also

Concepts

Working with Formulas (Report Builder 1.0)

Using Functions (Report Builder 1.0)

Aggregate Functions (Report Builder 1.0)

Report Builder 1.0 How-to Topics

Working with Literals in Formulas and Filters (Report Builder 1.0)

Formatting Data, Text, and Images (Report Builder 1.0)