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 only ...
Microsoft Dynamics CRM (Archived)

Calculated field only has an outcome when all summed up fields are filled in?

(0) ShareShare
ReportReport
Posted on by Elowy GrootCRM 54

We have a calculated total field that sums up 5 other numeric (5 decimals) fields. Not all fields have a value and can be empty.

That always worked well (empty fields are 0). However, today the total field is only calculated when all other fields have a value!!

Does anyone have a suggestion?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Ivan Burda Profile Picture
    Ivan Burda 115 on at

    Hi Elowy,

    does your fields have 0 in them or NULL as you said "Not all fields have a value and can be empty."?

    i suggest that you create business rule for default value 0.

    Maybe this will be helpful

    Good Luck

  • Elowy GrootCRM Profile Picture
    Elowy GrootCRM 54 on at

    Thanks Ivan. That will work fine, I guess. I can implement this.

    But I'm also curious if others experienced the same changing behavior of Dynamics.

  • Suggested answer
    Elowy GrootCRM Profile Picture
    Elowy GrootCRM 54 on at

    Regarding to MS support I have to create calculated fields for all values where I set the value to 0 if it does not contain data. That calculated fields I can use in the sum. Like Ivan explained. It was not clear how it could have been working well before, maybe I'm lost there. More info can be found here: crmtipoftheday.com/.../calculating-with-empty-fields.

  • Community Member Profile Picture
    Community Member on at

    Dynamics of the community are settlor the anticipation for the crowds. The range is filled for the use of the www.resumehelpservices.com/.../ for all paths for the field. The origin is placed for the assumption for the turns forth surrounding the forth ways for humans.

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