Calculates the average for a range of values in a list.
Syntax
x[AVERAGE: y]
where:
- x: value to average
- y: value specifying the list
Format
| Input Format | Output Format |
|---|---|
|
x: Number. y: List |
Number |
Arguments
The function uses the following arguments:
- x: Number: Numeric line item, property, or expression
- y: List
Constraints
The function has the following constraints:
- Line items used for mappings must share a dimension with the source line item.
- Result line item must be number-formatted.
- Result line item must have each list used for mapping applied to it as a dimension.
Excel equivalent
Example
In this example, an Employee Salaries source module shows staff Grade, Region, and Salary.
The module has an Employees list as a dimension on Rows. The line items are on columns: Grade and Region is list-formatted on the Grades and Region lists respectively:
A results module has City Location as a dimension on Columns. We can then use AVERAGE in an Average Pay for Region, number-formatted, result line item to show the average employee salary paid in each region:
Employee Salaries.Salary[AVERAGE: Employee Salaries.Region]
Count Unique Values
The Count the Averages module allocates a CountVal of 1 to each Employee record.
The CountAverage module indicated where there is a unique combination of Grade and Region values, it does not count the number of occurrences. If there is no combination of a Grade value and a Region value, it returns 0.
For example, the Count the Averages table does not have a combination of Grade 1 and Region C, so the CountAverage table displays 0 at that intersection.
Count = Count the Averages.CountVal[AVERAGE: Count the Averages.Grade, AVERAGE: Count the Averages.Region]
