-
SQL "Sum" ERROR - wrong decimal place
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.
-
What is the data type of amt column?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|