Only one rollup per field working at a time

[agnaramasi]

I have a lookup field on the Opportunity object to the Opportunity object. I've created four realtime rollups on the Opportunity object to summarize values on the child opportunities related via this lookup: count and sum of the Amount field on the child records; and max and min of the CloseDate field on the child records.

The problem is only one rollup works at a time for each field on the child record. When the sum and count of Amount rollups are both active, only the count rollup works. When the max and min of Close Date rollups are both active, only the the Min rollup works. When I disable the count rollup, the sum rollup works fine; similarly, when i disable the min rollup the max rollup works.

I haven't encountered this issue on any other rollups -- perhaps it only affects rollups where the child and parent are the same object.

I can give you access to the sandbox where I've encountered this problem if that would be helpful. There are no DLRS logs or apex job errors, etc, that I've found.

Thanks again for the terrific tool!

[afawcett]

That would be good to take a look, if you can give me the name of the org so i can find it once you've granted access, also steps to reproduce, so i can safely update / insert records etc. Thanks. 👍

[agnaramasi]

Hi Andy, I've granted you access. (Through My Settings -> Personal -> Grant Account Login Access)
The org is a sandbox - https://cifar--advdev.cs10.my.salesforce.com
I've never done this before, so let me know if you need anything further from me to access the sandbox.

To reproduce the behaviour, you need to simply activate either of these rollups:

• "Donation: Deferred Gift Count" - when activated will make the rollup "Donation: Deferred Gift Amount" stop working
• "Donation: First Deferred Gift" - when activated will make the rollup "Donation: Last Deferred Gift" stop working

Please let me know how I can assist in any way; and I apologize for the delay in getting back to you.
Thanks again for this!
J

[afawcett]

Thanks so much for providing this info, can you give me the name of the person and company who installed the package so i can look it up in my Subscribers list please.

[agnaramasi]

The person is me, Jonathon Millard.
The company is the Canadian Institute for Advanced Research.
On Sep 24, 2014 3:46 AM, "Andrew Fawcett" [email protected] wrote:

Thanks so much for providing this info, can you give me the name of the
person and company who installed the package so i can look it up in my
Subscribers list please.

—
Reply to this email directly or view it on GitHub
#63 (comment)
.

[afawcett]

Thanks I'll take a look!

[jjulicher]

Also - not sure if it's only one rollup per field - I think it's more along the lines of a count + sum or comibination of two as I have to sums on the same field but with a different filter working. However, I have another 2 rollups with counts and they don't work, all 4 roll-ups are on the same child object.

[xiteer]

I have done some additional testing and I'm not able to get a min and max on the same field to work either. It appears to only calculate the 'last' entered rollup summary.

[afawcett]

Yes I can see now whats going on, basically multiple rollups to the same parent Aggregate Result Field are not supported. The workaround is to create separate fields on your parent object for each rollup, then use a formula field on the parent to add them together.

[afawcett]

Fixed, in v1.14.