Roll-up summary field limits
Key Takeaway
An object can have up to 25 roll-up summary fields, and creating one locks parts of your design.
A roll-up summary field sits on a master record and calculates a value from its related detail records, such as a count of those records or the total of an amount field. Roll-up summary fields have firm limits on where you can create them, which fields they can summarize or filter on, how many an object can have, and what you can no longer change after they exist.
Where you can create roll-up summary fields, and how many
You define a roll-up summary field on the master side of a master-detail relationship to summarize the detail records.
For example, an account can show a Total Invoice Amount field that sums the amounts of its related invoice custom object records.
You can create a roll-up summary field on any custom object on the master side of a master-detail relationship. You can also create one on any standard object on the master side of a master-detail relationship with a custom object.
Some pairs of standard objects also work:
- Opportunities can summarize opportunity products.
- Accounts can summarize related opportunities.
- Campaigns can summarize campaign member status or campaign member custom fields. Campaign member custom formula fields that reference fields derived from leads or contacts aren't supported.
An object can have up to 25 roll-up summary fields.