Search…
⌃K
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

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