Excell 2007 Pivot Table Calculation changes decimal places

  • Thread starter Thread starter FStJ
  • Start date Start date
F

FStJ

I have a file that contains a table with source data built to 2 decimal
points. When I compare values across a defined type, the source data with
multiple occurances (both positive and negative values) converts from 2
decimals to an endless stream (example 52284.8 reflects as 52284.799999999...
in the pivot table.
Since I want a logic formula to build off of a zero difference, this returns
0.00 in accounting format and does not work properly with the if statement.
I can recreate the data, so I have a small file with the problem.

I have found a work around by using the ROUND command, but do not understand
why I have to do this when the source data does not extend beyond 2 decimals.
 
Hi,

What type of calculation are you doing in the Data area of the pivot table?
SUM, Average, Count?..

Are you sure that all the source data is to 2 decimal places, not just
formatted to two decimals?
 
mThx for the response. The calculation is a difference (cell minus cell).
Yes, I manually over rode the data to two decimal points to test, and still
received more decimals in the pivot.
General format was used.
 
Back
Top