News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Rollup SUM Field Not W...

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

Rollup SUM Field Not Working

(0) Share

Report

Report

Posted on by D365 User 06

70

Hi,

I have 2 related entities - Reviews & Final Approval. For each proposal there would be multiple review records by multiple people, but there will only be 1 record of Final Approval. Review form has a field called 'Review Score' given by each reviewer, and in my Final Approval form, I have a field called 'Final Score' which would be the sum of all the scores from all the review records. I tried using Rollup to get that sum in my Final Score field, but somehow its not working. Its always showing 0, I keep 'Recalculating' it, but still the value remains 0. Here are few screenshots...

My Roll-Up Setting...

This is my field on the form...

Can someone please tell me what wrong am I doing?

Thanks!

All responses Img

All responses (1)

Answers Img

Answers (0)

Gerry Canning 25 on at

Like (0)

Report

RE: Rollup SUM Field Not Working

Does it work if all reviews have something in the review score?

I know you are filtering for where it doesn't contain data, but something about this is ringing a bell.

I recall having to ensure that the field being rolled up contained 0 rather than Null.

Also, if this is a new feature you are implementing, when you make changes and go back to test, be sure to hit F5 on the Final Approval form.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,916 Super User 2025 Season 1

#2

Martin Dráb 231,782 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans