Let’s think of a scenario in which I have a number field called Total Apples. If Record 1 has a 7 in this field, and Record 2 does too, your need is to have that 7 included only once in the sum, instead of twice?
If that’s what you’re after, there doesn’t seem to be a straightforward declarative way to accomplish this, though that doesn’t preclude a scripted solution. Since we always encourage declarative solutions, my inclination would be to try and set up a condition on your aggregate model that only pulls in one record per each value in Total Apples. That may require subqueries and other fancy footwork though, which gets a bit in the weeds.
