0
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 of all invoice totals in the Invoice table.
Reply
Content aside
Related Articles