VAR (Report Builder)
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)
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)