Forum Discussion
Calculated items issue in pivot table
You need to explicitly round the formula in J2. Instead of =H2-I2, write =ROUND(H2-I2, 2).
Alternatively, explicitly the sums in H2 and I2.
If you are letting the Pivot Table do these calculations automatically, you need to replace them with a Calculated Field, where you enter the formula yourself.
-----
The infinitesimal difference arises because of binary arithmetic and Excel anomalies. In a nutshell, Excel represents decimal numbers in binary internally. Most decimal fractions cannot be represented exactly, so they must be approximated in binary. This gives rise to infinitesimal differences, which Excel does not always show. For example, =SUM(123.45,56.78,-180.23) displays 2.82E-14 when formatted as General. But =123.45+56.78-180.23 displays exactly zero.