Aggregates

The following aggregate types are supported:

Sum (Sum)

Avg (Average)

Min (Minimum)

Max (Maximum)

Count (Count)

StDev (Statistical standard deviation)

Var (Statistical variance).

For example, to create a summary of figures in a column named Price:

Sum(Price)

Note: If you use a single table to create an aggregate, all rows would display the same value in the column.

If a table has no rows, the aggregate functions will return null.

An aggregate can only be applied to a single column and no other expressions can be used inside the aggregate.