Avg

Avg(column) · Aggregation

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

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.