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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table grand total location 1
Referencing a pivot tables Grand Totals Column 1
calculate grand total 2
Grand Total for Rows not Working in a Pivot Table 1
Grand Totals for Pivot Tables 4
Pivot Table Grand Total 3
I can't see Grand total rows even though the option's switched on 2
Pivot Table Calculates the Difference in Grand Total 2

Back
Top