Rollup
Aggregate values from related records.
Type
rollupValue
Computed
Unique
No
Rollup calculates a number from rows linked by Relation or Multi Relation. You do not pick a value. Changing Config does not rewrite existing cells until you Recalculate values.
Name, key, hidden, and permissions are the same for every column — see Tables.
Configure
| Setting | Description |
|---|---|
| Relation Field | The Relation or Multi Relation column on this table. |
| Aggregation | Sum, Average, Count, Min, or Max. |
| Target Field | Field on related rows to aggregate. Count can skip this (counts rows). Sum, Average, Min, and Max only list number-like fields (number, currency, rating, duration, progress, rollup, or a formula that returns a number). |
| Filter related rows | Optional. Opens a dialog to filter related rows (for example only paid orders). Same filter builder as table filters. |
Empty related set: Count is 0; other aggregations are empty.
Use case
- Order Line total as sum of linked product prices.
- Customer Revenue as sum of linked order totals, optionally only where status is paid.
- Order count on a customer using Count and no target field.