AVERAGE() : calculate an average

The AVERAGE() function calculates the average of a set of numbers (sum of the values divided by the number of values), and returns a number. It is compatible with fields from a relation: the calculation is then applied to all linked items.

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

1 value1 Set of numerical values.

2 value2… (optional) Other sets of numerical values.

Non-numeric values are ignored. The output format (integer or decimal) can be configured in the output field options of the formula editor. See Output format options in the Formula column article.

Examples

Calculating a simple average

AVERAGE(10, 15, 20)

Result: 15

Go further

MEDIAN()

The middle value of a set, less sensitive to extreme values than the average.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.