Stuart McLachlan
stuart at lexacorp.com.pg
Thu Dec 22 14:42:41 CST 2011
It depends on the situation. If you are rounding prices to the nearest 10c, accountants don't like accounts that show : Item 1 0.60 Item 2 0.60 ============ Total 1.10 If you want the total to equal the sum of all of the line items, you need to round each item (using either ROUND() or FORMAT(). and sum the rounded result. That is standard practice in accounting. -- Stuart On 22 Dec 2011 at 12:02, Mark Simms wrote: > Instead of using the number format to properly display the numbers, > the original developer would use the Format function to round a large series > of individual values, > and then total-up the rounded results instead of the original values. > As you are aware, precision is likely lost in doing it this way. > Ex: .55+.55=1.1 > His method would be to first "round-up" the .55 to .6: > Ex: .6+.6=1.2 > In this case, the total is now "off" by almost 10% ! > > And...this is a vital model that helps to run the company's main processing > unit. > > Wowzer indeed. > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >