What if you try an AVG instead of a Sum, does that give you the correct number?
or what happens if you right-click on the pill and make it a Dimension?
Thanks for the reponses. I worked through this and got it working.
I do have another issue, but is deservative of another thread.