10-28-2013 01:07 AM
This weird value is a very small number. I strongly assume this is caused by some precision issue. Does your data source come from a data base?
One way around this:
SUM(round(AMT,0.00000000001)) AS ID_AMT,PROVIDER
10-28-2013 05:21 PM
Using a format won't resolve the precision issue but will only mask it. I believe what the OP needs to do is to find an explanation why there is such a precision issue and then resolve it.
One reason can be that the data originates from a database. Numeric precision has been discussed here in these forums multiple times, it's documented and there are also whitepapers around.