Skip to content

Sum

Sum(column) · Aggregation

Adds the column over the rows in the current filter context (SQL SUM). NULLs are skipped; over zero rows the result is blank (NULL) — wrap in Coalesce([Measure], 0) when you want zeros.

Revenue := Sum(Sales.Amount)
  • The argument is a column, not a measure — Sum([Revenue]) fails with SQX013; a measure already aggregates.