Bill,
Your formula is adding the first rows of the aggregate models together. If your groupings are rollup, then you need to access the LAST rows of those models to get the SUM of each.
This is a little tricky, but if you have a ‘category’ field on each model, you can access if with something like this:
MODEL_LOOKUP(“Member_DNA_Point_Tracker”, “YourGroupingField”, “sumPointsc”, null)
Just going by memory here. I may have gotten the two middle arguments backwards… check the documentation to be sure.
