Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
decimal places | Excel Discussion (Misc queries) | |||
Decimal Places | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
decimal places | Excel Discussion (Misc queries) |