Excell 2007 Pivot Table Calculation changes decimal places

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

Shane Devenshire

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?
 
F

FStJ

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.
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
Doughnut Chart linked with the slicer in the pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Mail Merge - displaying a conditional number of decimals 5
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Data Aggregation 0
Cumulative formula for word table 0
DATE Calculations in pivot table 0

Top