The AVERAGE() function calculates the average of a set of numbers (sum of the values divided by the number of values).
Function compatible with fields from a relation: the calculation is then applied to all linked items.
Numeric function name :
AVERAGE()
Syntax
AVERAGE(value1, value2, …)
ℹ Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to be added between quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
value1 |
Set of numerical values |
value2… |
(Optional) Other set of numerical values |
Example
AVERAGE(10, 15, 20)
Result : 15
Notes
- Non-numeric values are ignored.
- If the input is a field from a relation, the average is calculated over all linked items.
Return type
The function returns a number.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula column article.