Features and Limitations of Dynamics 365 Calculated Fields
In Microsoft Dynamics 365, calculated fields let you automate manual calculations used in your business processes.
Features of Calculated Fields
Limitations of Calculated Fields
Maximum of 10 unique calculated fields per Table
The calculated field values are not displayed in the Dynamics 365 Outlook Offline mode in the tile views or on entity main forms.
A maximum number of chained calculated fields is 5.
A calculated field can’t refer to itself or have cyclic chains.
Sorting is disabled on:
A calculated field that contains a field of a parent record.
A calculated field that contains a logical field (for example, address field).
A calculated field that contains another calculated field.
Calculated fields can span two entities only.
A calculated field can contain a field from another entity (spanning two entities – current entity and parent record).
A calculated field can’t contain a calculated field from another entity that also contains another field from a different entity (spanning three entities):
(Current Entity)Calculated Field <- (Parent Record) Calculated Field 1 <- (Parent Record) Calculated Field 2.
You can’t trigger workflows or plug-ins on calculated fields.
You can’t change an existing simple field to a calculated field. If your current application is using JavaScript or plug-ins to calculate a field, you would not be able to use the calculated fields feature without creating a new field.
Duplicate detection rules are not triggered on calculated fields.
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.
Gotchya’s
If you change one of the condition operators in a multiple condition clause, all of the condition operators will update to that condition. For example, in the clause IF (x > 50) OR (y ==10) OR (z < 5), if you change the OR operator to the AND operator, then all OR operators in the clause will become AND operators.
You can access parental fields via the Lookup field to the parent entity, such as <LookupFieldName>.<FieldName>. This is not possible with multi-entity Lookup fields like Customer which can be Account or Contact. However, some entities have individual Lookup fields for a specific entity, such as ParentAccountid.<FieldName> or ParentContactid.<FieldName>.
Photo by Davis Sanchez: https://www.pexels.com/photo/close-up-photo-of-traffic-light-2652968/