Albert, the full result of (23850 * 0.4261) is 10162.485
so I think that 6.5++ is right and 6.1A is wrong. Polychronis Kontos Athens, Greece -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Albert Berry Sent: Tuesday, August 19, 2003 5:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Currency rounding difference 6.1A vs 6.5++ We have run across an interesting anomaly between 6.1A and 6.5++. This has the unfortunate effect of creating a balance due of $0.01 on a large number of transactions, because of a computed column that updates $0.01 higher on reload. We have not done enough testing to ensure that BRND would resolve the differences in their entirety. We are reverting the system to 6.1A until we can figure out how to accommodate this calculation. 6.1A R>SET VAR vCurr CURRENCY = (23850*0.4261) R>SHO VAR vCurr R> 10,162.48 6.5++ R>SET VAR vCurr CURRENCY = (23850*0.4261) R>SHO VAR vCurr R> 10,162.49 (BRND(23850*0.4261,10,.01)) = 10,162.48 -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
