Applicable plans
- Free
- Plus
- Business
- Enterprise
Aggregations are not a field in and of themselves. When you create an aggregation, it creates a formula field using number fields from inside referenced lists.
Read the guide to formulas and aggregations to learn more about how to use this formula building wizard.
The following functions can be used to calculate new values using referenced data:
| Function | Description | Example |
| sum({reference list: number field}) | Sum. Accepts a reference as a parameter and returns the sum of all values in referenced items. | sum({Financial:Invoice Total}) |
| avg({reference list: number field}) | Average. Accepts a reference as a parameter and returns the average of all values. | avg({Astronauts:Wage}) |
| count({reference list: number field}) | Count. Accepts a reference as a parameter and returns the number of value supplied. | count({Flight Plan:Astronauts}) |