46
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
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.
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.
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.
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
#1
André Arnaud de Cal...
292,884
Super User 2025 Season 1
#2
Martin Dráb
231,760
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
