Avg

Aggregation

Avg(column)

SQL AVG over the current context. NULLs are skipped (they reduce the denominator, unlike zeros). Blank over zero rows.

When to use it

The mean of a column at row grain — average line amount, average response time.
For average per customer/region questions, compute the per-entity value first with Fixed or Include and average that — a plain Avg over line rows answers a different question.

Example

AvgAmount := Avg(Sales.Amount)

Good to know

Avg is accepted under YTD/RollingSum — the compiler decomposes it into windowed SUM(sum)/SUM(count).
For “average per customer”-style questions at a coarser grain, compute the per-entity value with Fixed and set the chart aggregation to avg.