0

I find that if I don't round the Summed values in the below query, I get a random number with a long decimal value for values that should be 0. When I round it as shown below, this solves the issue. It only affects zero (0) values. Any idea what's going on?!

SELECT     
    AccNo, AccType, ROUND(SUM(amount), 4) AS balance
FROM
    TRANS_Table
WHERE     
    (comp = 'XXX') AND (transdate <= @AsAtDate)
GROUP BY 
    AccNo, AccType
ORDER BY 
    AccNo

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
ZigL
  • 3
  • 6

0 Answers0