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 collections.
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 collection: 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 collection: number field}) | Average. Accepts a reference as a parameter and returns the average of all values. | avg({Astronauts:Wage}) |
| count({reference collection: number field}) | Count. Accepts a reference as a parameter and returns the number of value supplied. | count({Flight Plan:Astronauts}) |