[RBASE-L] - RE: Currency rounding difference 6.1A vs 6.5++

[J BLAUSTEIN]

I found that I have resolve the rounding problem with converting currency 
to integer   by using NUMERIC (12,0) - for ex. 100.26 * 100  if the 
variable was an integer the results was 10025, if numeric the results was 
10026 - I think it has to be the bank rounding feature
J

At 10:49 AM 8/20/2003 +0300, you wrote:
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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================