web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Calculated Field to su...
Microsoft Dynamics CRM (Archived)

Calculated Field to sum 12 fields - Help!

(0) ShareShare
ReportReport
Posted on by plesq 100

Hello everyone.  I'm trying to create a simple calculated field to show total 2017 revenue (the sum of 12 fields Jan through Dec).  I created the calculated field by typing field1 + field2 + field3..... + field 12 and the resulting value of the calculated field is null.

When I did a test of summing 2 fields everything works ok.  When I include all 12 the calculated field results are blank.

Can anyone help?  Each of the fields is a basic currency field so I'm not trying to add 12 calculated fields.

25606.1.png

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hello

    What are the types of fields you are calculating ? if they are also calculated fields or rolup fields, CRM has a limit of 5 for those.

    For more information about the limitations of calculated fields see here:

    technet.microsoft.com/.../dn832103.aspx

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hello

    What are the types of fields you are calculating ? if they are also calculated fields or rolup fields, CRM has a limit of 5 for those.

    For more information about the limitations of calculated fields see here:

    technet.microsoft.com/.../dn832103.aspx

  • plesq Profile Picture
    plesq 100 on at

    Hi OQL - they are regular currency input fields (simple currency precision 0)

  • Verified answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,401 on at

    Hi

    If any of the field, you are using within the calculation is blank, then you will not get a result. The result would be blank in this case.

    So you have to populate the field with 0, if it is blank.

    You can use Business Rule to do this as below:

    1. Condition: if the field Does not contain data
    2. Action: set Field value to 0

    You can also use JavaScript to set the value to 0 when it is blank.

  • plesq Profile Picture
    plesq 100 on at

    Gopalan - that is exactly what the problem was.  I did as you suggest and created a business rule (also made sure the business rule was on the entity not just the forms) and worked like a charm.  Thank you!

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans