Bernie: I believe that what you need is the BRND function, enclosed is the description from the help files, hopefully it will solve your problem...
Syntax: (BRND(arg1,arg2,arg3)) The first argument of the function is the number to be rounded. The second argument is the total number of digits to return in the result. You can just leave this at 15, for example, if you want to return all digits. The third argument of the function indicates where to round. This is the one that is often hard to figure out. It is easiest to think of this argument as the number of zeros or places to keep and then round the next place. For example, .001, is two places or zeros to keep and then the next number to the right is rounded. 1000 is three places or zeros to keep and then the next number to the left is rounded. You can easily see this by looking a series of BRND functions: The starting number is 1234567.76543 (BRND(1234567.76543,15,0.0001)) returns 1234567.7654 (BRND(1234567.76543,15,0.001)) returns 1234567.765 (BRND(1234567.76543,15,0.01)) returns 1234567.77 (BRND(1234567.76543,15,0.1)) returns 1234567.8 (BRND(1234567.76543,15,1.)) returns 1234568. (BRND(1234567.76543,15,10.)) returns 1234570. (BRND(1234567.76543,15,100.)) returns 1234600. (BRND(1234567.76543,15,1000.)) returns 1235000. (BRND(1234567.76543,15,10000.)) returns 1230000. The BRND function does what is called Banker's Rounding. If the number to be rounded is even at the rounding digit, then the number is not rounded. If the digit is odd, then the number is rounded. Look at an example rounding to two decimal places. BRND(1234567.765,15,0.01) returns 1234567.76 BRND(1234567.775,15,0.01) returns 1234567.78 The odd number, .775, is rounded, the even number, .765, is not. The digit that is used to test odd or even is the digit at the rounding location, in this case the number two decimal places to the right. Valid data types: REAL, DOUBLE, or CURRENCY. BRND function has been enhanced to handle very small as well as very large values. Examples of using BRND function when using very small and very large values: (BRND(0.01,6,0.01)) returns 0.01 (BRND(1.009,6,0.01)) returns 1.01 (BRND(0.009,6,0.01)) returns 0.01 (BRND(1999,6,1000)) returns 2000 (BRND(999,6,1000)) returns 1000 Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66962-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bernard Lis Sent: Tuesday, June 17, 2003 3:46 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: tax calc v6.5++ vs v7.0 Dennis, Bill,Terry,Javier Thanks but -- Round function reqires that amt be double. So I made it double and did the formula below and it still comes out to .55 should be 56. using more digits to right of decimal doesn't help because they are all .55555 My solution is to have the customer change his price to 9.26 <g> Bernie ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 1:10 PM Subject: [RBASE-L] - Re: tax calc v6.5++ vs v7.0 > So it seems the answer is to do calulations in double, round to the > correct decimal and assign to a currency. > > Here is how to force that even though original values are currency > > > set var amt CURR = 9.25 > set var txrate DOUBLE = 0.06 'WILL FORCE CALULATIONS TO BE DOUBLE > set var tax CURR = (ROUND((.amt * .txrate), 2) > > > Dennis McGrath > >
