4 Replies Latest reply on Mar 8, 2010 11:41 AM by RickWhitelaw

    Unintended Rounding

    spectre6001

      Title

      Unintended Rounding

      Post

      Job Type -< Job -< Invoice

       

      I have an aggregate sum function calculating the total amount received by Job Type in the Job Type table from the Invoice table. For example, there are four records with values of $494.89, $494.89, $498.00 and $498.00 in the Invoice table. The number returned is $1,990.00 instead of $1,985.78. All other sets are calculating the same way (they're rounding to the nearest $10). I've triple checked to make sure it's calculating from the correct field, and I did not set any rounding parameters. I looked to make sure there was nothing I might have somehow accidentally clicked, and I'm not finding anything. Why am I getting this rounded number?