Page 1 of 1

Rounding method

Posted: Tue Dec 31, 2002 4:55 pm
by cooperds_(Guest)
The method apparently used in R&R v9 to round numbers is not consistant with the rounding produced by our rdbms (Oracle) directly. ____For example, R&R rounds 0.25 up to 0.3, but 0.15 down 0.1. __ (rounds 5 up if preceeding digit is even, __ rounds 5 down if preceeding digit is odd)____Oracle rounds 0.25 up to 0.3 and 0.15 up to 0.2.__ (always rounds 5 up)____Is there a way to configure R&R to use the standard method (always round 5 up)? (I didn^t find anything about this in the online help.)____Thanks..

=> RE: Rounding method

Posted: Tue Dec 31, 2002 5:44 pm
by kfleming
The article http://www.livewarepub.com/ftp/TechDocs/Rounding_Numbers.pdf explains rounding in R&R.____Kathleen__R&R Support

==> RE: Rounding method

Posted: Tue Dec 31, 2002 6:14 pm
by cooperds_(Guest)
Thanks.. __This helps..