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.