I just had an epiphany as posting this!
Thanks for anyone that will look into this but I think I got it!
For anyone else that encounters such an issue, or just curious, this was the fix.
Took the posted workbook and added the following calculation. With this LoD calc it does look at individual state/segment and then rounds before summing:
This gave me matching numbers,
Hopefully may help someone.
lol thanks for that Deepak, you figured it out before me!
I will mark you correct. Thanks for looking into this!