Rules & Calculation Formulas · Calculation functionsOperational Master Data RepositoriesRules & Calculation Formulas
Average (arithmetic mean)
FN-6- Category
- Aggregation
The sum of the values divided by how many there are. Empty values are left out of both; no values stops the calculation.
SUM(Values) ÷ COUNT(Values)
Example: (100 + 200 + 600) ÷ 3 = 300