Wondering if anyone else has experienced this odity - I am performing a simple sum on 4 values in a table - if I select the 4 values and use a compute sum(amt) the value is correct (-5812.5000). If I use the sum(amt) I get -58125.0000
select distinct sum(amt)
from blah blah
Here are the detail amt values it is trying to sum up
-3180.0000
-2032.5000
-600.0000
.0000
any clues? thanks.
