Microsoft Dynamics CRM (Archived)

Maximum number of calculated fields

(0) Share

Report

Posted on by Dynamics Pawan Kumar

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 have the same question (0)

All responses (4)

Answers (1)

Suggested answer

jlattimer 24,562 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Dynamics Pawan Kumar on at

Like (0)

Report

Thanks Jason and Goutam. The shared link is useful for me. Much Appreciated.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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/.../

Was this reply helpful? Yes No