Subtotal Calculation Not Correct

[Anonymous]

Can someone help me figure out why the subtotal in this pivot chart is not correct? The lines below it are correct but the subtotal should be 837 instead of 800 and I can't see what the problem is.

[Anonymous]

[Anonymous]

But that still doesn't explain why the detail lines are correct but the total is not.

[sunny_talwar · Accepted solution]

So it does make sense then

(0.46608409-0.46512778) * 837005 = 800.436251550013

[swuehl]

This is what I get, manually calculated with the precision shown:

800,43625155

Seems ok to me.

[Anonymous]

Oh wow, I never would've thought the precision would change the result that much. Thanks guys! (I'd mark both of you correct it would let me)