Check out the latest Sales updates!Learn about the key capabilities and features of Dynamics 365 Sales and experience some of the new features.
Download overview guide | Watch Sales video
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
I have a scenario where I have four fields which are currency fields.
I have created a field that will sum the four fields, I want it to plus field A+B+C+D.
Which is the best way to achieve this, to make sure the Sum field plus each of these four fields. So for example, if I only have two fields filled and other two blanks, the Sum field should sum the two ones
You can refer to the verified answer in below:
There are two solutions to this problem.
I introduce the first way here.
Because as long as one of the four fields is empty, the field 'sum' will be empty. So we have to make the empty fields 0 first.
In order not to change the values of the four fields themselves, we need to create auxiliary fields for them.
Finally, we use 4 auxiliary fields to set the calculation field.
The downside is that four auxiliary fields are displayed on the form and are seen by users.
Here are the detailed steps:
1) This is field 'A' and its auxiliary field 'A copy'. The other three fields are B, C, and D. Add them to the form.
2) Create four business rules, set as follows:
A contains data
Set A copy to A
Set A copy to 0
Create the same business rules for B, C, and D.
3) Create a calculated field 'sum' and set its logic to 'A copy + B copy + C copy + D copy'.
4) Finally, set the four auxiliary fields to read-only on the form.
The effect is as follows:
Lu, you're the Man, keep up the good work and huge thanks!!!!!
Business Applications communities