Excell 2007 Pivot Table Calculation changes decimal places
 

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.




--
FStJ

Excell 2007 Pivot Table Calculation changes decimal places
 

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"FStJ" wrote:

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.




--
FStJ

Excell 2007 Pivot Table Calculation changes decimal places
 

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.
--
FStJ


"Shane Devenshire" wrote:

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?

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"FStJ" wrote:

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.




--
FStJ