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 07:25 AM
Give it a proper format like :
create table test as
select sum(AMT) format = 12.5 as sum ,ID from source_table
group by ID;
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.