Unless I’m not understanding something, Rollup is failing to SUM properly. (or rather, consistently properly.)
I’ve made an isolated example of the issue here:
Rollup not working with SUM operations
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.