Thanks Emma, that was very helpful.
Bob, I recalled that you had warned me against the aggregate including subcategories. I only included here as further description of what I saw happening with the math. Agree with you on SWMG. We are in an unfortunate situation where the SIS we connect to requires that aggregation method so we are stuck
thanks again for all your help!