error in Pivot grand total

  • Thread starter Thread starter Magnus
  • Start date Start date
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?
 
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.
 
Back
Top