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.