Aggregation is usually performed in a parent table over a child table, as a function applied to a child field. Example: Sum(Child(Orders – OrderDetails).Quantity). Used in the Orders table, this expression calculates the sum of the Quantity fields of the OrderDetail table rows related to the Orders row.

Supported aggregation functions: Sum, Avg (average), Min (minimum), Max (maximum), Count, StDev (statistical standard deviation), Var (statistical variance).