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 population variance of non-null values in a set.
Syntax
VAR(aggregate)
aggregate |
Specifies the field name or formula to aggregate. |
Remarks
- VARP assumes that its arguments are the entire population. If your data represents a sample of the population, then compute the variance using VAR.
- Logical values such as TRUE and FALSE, and text are ignored.
Examples
| Formula | Result |
|---|---|
VarP(Sum Total Due) |
Returns the variance for the sales sum total that is due. The value returned is similar to the following: 14768854.2951954. |
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)