Search…
Resources
Related Links
avg
To return the average value of a number array
Calculate the mathematical average of numeric values from an array or a table with this function.
For example, you can calculate the average revenue per order or the average payment duration of invoices in days, etc.
You can use the function also on table views in columns with numeric values.

Syntax

avg([number])

Return

number

Examples

avg([1,2,3,4,5,6,7,8,9])
Result: 5
avg(select Invoices.Total)
Result: Average value of all invoice totals in the Invoice table.
Last modified 2mo ago
Export as PDF
Copy link