Results 1 to 2 of 2

Thread: SQL "Sum" ERROR - wrong decimal place

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •