Hi,
I am looking for the maximum number of calculate field on Entity and in organisation?
Regards,
Pawan Kumar
*This post is locked for comments
I am working on version 1612 (9.0.16.7) (DB 9.0.16.7) on-premises
I don't see that there is a limit on the number of calculated fields per entity.
Interesting Link about how many fields you can create in an Entity: www.marksgroup.net/.../
Thanks Jason and Goutam. The shared link is useful for me. Much Appreciated.
Hi Pawan,
Microsoft does not mentioned the limit of maximum number for calculated fields . Within each entity there is an upper limit on the number of fields you can create. This limit is based on the technical limitations on the amount of data that can be stored in a row of a database table. It is difficult to provide a specific number because each type of field can use a different amount of space. The upper limit depends on the total space used by all the fields for the entity.
Although Microsoft mentioned some imitation while creating calculated field are as follows -
-A maximum number of chained calculated fields is 5.
-Saved queries, charts, and visualizations can have a maximum of 10 unique calculated fields.
Fore more information please visit -
https://social.technet.microsoft.com/wiki/contents/articles/37177.dynamics-365-online-limitations.aspx
Hope this helps.
Not sure there is an official number but you can find more detail about the other limitations here:
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/calculated-rollup-attributes
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Aric Levin - MVP 2 Moderator
HR-09070029-0 2
MA-04060624-0 1
