Contents
What is a roll-up field?
Rollup fields are designed to help users obtain insights into data by monitoring key business metrics. A rollup field contains an aggregate value computed over the records related to a specified record, such as open opportunities of an account.
How do you make a roll up field?
How to Create a Rollup Field in Dynamics 365 for Sales
- Create a new field for the Account entity.
- Choose your Data Type as you would when creating any new field (single text, currency, etc.).
- Choose your Field Type as Rollup.
- Define your other field details.
Can a rollup field be part of a calculated field?
You can easily transport the rollup fields as components between organizations and distribute them in solutions. Rollup fields and the calculated fields are complementary to each other. You can use a rollup field as a part of the calculated field, and vice versa. Some examples of rollup fields include:
How many rollup fields can be defined in Dynamics 365?
You can define a maximum of 100 rollup fields for the organization and up to 10 rollup fields per entity. A workflow can’t be triggered by the rollup field updates. A workflow wait condition cannot use a rollup field. A rollup over the rollup field is not supported.
The reason why you met this problem is that: A rollup can be done only over related entities with the 1:N relationship. A rollup can’t be done over the N:N relationships. You can define a maximum of 100 rollup fields for the organization and up to 10 rollup fields per entity. A workflow can’t be triggered by the rollup field updates.
Can a workflow be triggered by a rollup field?
A workflow can’t be triggered by the rollup field updates. A workflow wait condition cannot use a rollup field. A rollup over the rollup field is not supported. A rollup can’t reference a calculated field that uses another calculated field, even if all the fields of the other calculated field are on the current entity.