Tom,
First, thanks for submitting the ROUND function boo-boo to R:DCC in the latest and greatest beta for in-line patch-3. Your efforts are greatly appreciated. Now, it gives me great pleasure as I write this e-mail to let you know that your reported boo-boo to R:DCC on Saturday, 12 Oct 2002 14:06:17 +1000 has been FIXED. Stay tuned for the lovely e-mail from R:DCC to receive the private beta to test the ROUND function before they announce the official release. Enjoy the benefits of staying CURRENT and make sure to have fun! Very Best Regards, Razzak. At 02:11 PM 10/12/2002 +1000, Tom Grimshaw wrote: >Dear Javier, > >At 22:49 11/10/02 -0500, you wrote: >>Tom: >>I am running the latest patch. I ran the enclosed code and it is not >>truncating, it is rounding incorrectly. >>The value of vRawTaxAmt = 50.43 / 11. = 4.58454545... >>After the third line the values shows as 4.59 where the correct rounded >>value (TTBOMK) at 2 decimal; places should be 4.58; if the value would be >>truncated it would actually show 4.58. I have tried several variations with >>the same result. At 3 decimal places the correct rounded value should be >>4.585 but a t 2 decimal places it should be 4.58. I wonder if the function >>incorrectly does a sequential rounding starting from the right and rounds >>5.585 to 5.59, this would be incorrect. >>You can verify this easily by plugging the numbers into an excel spreadsheet >>and displaying the result formatted with 3 and 2 decimal places, the results >>will be 4.585 and 4.58 not 4.59. >>So, in short, as far as I can tell, the ROUND function rounds the value >>incorrectly. You should do the honors and submitted to the RDDC. > >Done deal! > >Thanks for checking for me. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
