Thanks for the reply Mark.
It might be slightly different in my case. I have an aggregate model with tasks and I want to SUM a Lifetime Value field (currency) on Account. I’m going from Task -> Contact -> Account. The challenge I’m having is that if I have two Tasks on two separate Contacts that are from the same Account then Lifetime Value is getting double counted. I only want it to be counted once in this case.
COUNT DISTINCT handles this properly, so I’d basically want the exact same functionality but with SUM.
I hope that makes sense.