Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
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 and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
Hello All - I have a few calculated fields that are taking Rollup Fields and either dividing or multiplying by another field but my problem is that the calculated fields are not automatically updating unless I open the record that the calculated field is in and refresh. Is there a Workflow that I can create that will update these fields or force an update ?Thanks for your help.
Here is custom workflow activity that can help you - calculaterollupfield.codeplex.com
That is the default behaviour of Rollup fields.
You can use the custom workflow activity as mentioned by Andrii.
I used it, and it was working fine. And there was additional requirement of more calculated fields (max 10 allowed per entity).
We cannot add more than 10 per entity. So, I removed all the calculated fields and use simple fields. I had to use workflow to achieve this functionality (little bit clumsy way of doing it).
Please check the following link for considerations:
Hi - Thank you for your reply. It's actually the Calculated Fields that I'm trying to get to update, the roll-up fields are good but the Calculated Fields that I have associated with them will not update unless I open the record. For example, I have a "Rollup" Field that sums up the number of product and then I have a "Calculated Field" that takes that Sum and divides it by # of Weeks in order to get an Average but the only way I can get the "Calculated Field" to populate is to open the record, refresh the roll-up and save the changes and then it will populate the field.
Did you find any solution since ? Because I have the same issue and I still didn't find any solution for it
Calculated fields are not stored, but are calculated whenever you access the field; there is no concept of refreshing a calculated field. If the fields that the calculated field are based on are up-to-date, the calculated field will also be up-to date
Hello, you can use call the CRM native API and update the value in the database just after you calculate the roll up field. If a form is opened afterwards then no worries. If the form is open during this time, then just after the API call you can then retrieve the updated value via JS API call and use XRM commands to replace the updated value in the form. Its working very well for me. Happy to provide you with more details if interested in this approach.
Hi Mohamed, without any coding nice and clean solution is use the Dynamics 365 workflow tools by Demian, you can install the solution and add in the workflow step to trigger when rollup field is updated in child record.
Business Applications communities