AnsweredAssumed Answered

Unintended Rounding

Question asked by spectre6001 on Mar 6, 2010
Latest reply on Mar 8, 2010 by RickWhitelaw


Unintended Rounding


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?