The VARP aggregation function returns the population variance of a given line item.
This function can be useful for analyzing total employee performance rating variance by department or total sales revenue variance by region.
Syntax
Source[VARP: Mapping, VARP: Mapping 2, etc.]
Arguments
| Argument | Data type | Description |
| Source | Number | The values to return the population variance of. |
| Mapping | Date, time period, list | The mapping that determines which values to return the population variance of. This argument can be repeated to provide multiple mappings. |
The VARP aggregation function returns a numeric result.
Calculation engine functionality differences
This function is only available in the Polaris Calculation Engine.
Syntax example
'Annual Performance Reviews'.'Final Score'[VARP: 'Employee Department Map'.'Department']
Additional information
- The population variance of a single value is zero.
- The population variance of a set of values, which includes NaN, is NaN.
- The square root of VARP is equal to STDEVP. See Related Anaplan functions, below.
Constraints
- You can't use VARP with another number-typed aggregation function.
- VARP returns zero for unmapped points.
- You can't use VARP together with the Formula summary method.
- You can't use VARP in version formulas.
Excel equivalent
Examples
Example 1: Analyze total employee performance rating variance by department
Example 2: Analyze total sales revenue variance by region
