Rollup SUM Field Not Working

(0) Share

Report

Posted on by D365 User 06

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!

I have the same question (0)

All responses (1)

Answers (0)

Gerry Canning 25 on at

Like (0)

Report

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.

Was this reply helpful? Yes No