Round off in a query which is sum of a coulmn

[sunilggssverma]

Dear All

I have data in a particular column. My data have decimal only up to two decimals but when i am running query to sum them it show too many numbers after decimals. how can be it possible because i have decimals up to 2 places in my data.

I have also tried round off function.........when i round off it to 1 its working perfectly fine, but when i am rounding up to 2 its not working. My Data is in a "Double data type".



Please help me guys.

[anthgav]

Can you provide your code including the round function?

[June7]

Cannot replicate issue.

Post sample data and query statement.

Are you sure data is entered with no more than 2 decimals?