error in Pivot grand total

M

Magnus

Hi
I'm having trouble with the grand total in my pivot.
It doesn't calculate right
I have 4 numbers
-3,101000000000000000000000000000
-7,663000000000000000000000000000
3,101000000000000000000000000000
7,663000000000000000000000000000
Added toghether these should become 0, and they do if i
use the SUM function
But my grand total in the pivot calculates it to a very
smal decimal number.
0,000000000000000888178419700125

Anyone have any idea what could be wrong?
 
P

Paul

Magnus said:
Hi
I'm having trouble with the grand total in my pivot.
It doesn't calculate right
I have 4 numbers
-3,101000000000000000000000000000
-7,663000000000000000000000000000
3,101000000000000000000000000000
7,663000000000000000000000000000
Added toghether these should become 0, and they do if i
use the SUM function
But my grand total in the pivot calculates it to a very
smal decimal number.
0,000000000000000888178419700125

Anyone have any idea what could be wrong?
Click to expand...

Nothing's wrong. Excel, like all computer programs, calculates to a finite
precision. Anything smaller than this is not defined. Results of
calculations are correct to about 15 digits. The tiny inaccuracies are
called rounding errors and should be ignored.
 
Top