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