Rounding problem large dataset.

[PantoKing]

Hello,

I am currently having a problem with rounding of a large dataset (1.5 million records). I have run the round function to 2 decimal places and every record seems fine. However when I sum these rounded records i am getting additional decimal places. i.e. .0299958.

Has anyone got any ideas what may sort this problem.

Thanks in advance!

Make things as simple as possible — but no simpler.

 

[Golom]

Check the data types of your fields. If they are floating point types (Single or Double) then note that a float may not be able to exactly represent a decimal number. Try converting them to scaled integer types (Currency or Decimal).