Rounding method

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
cooperds_(Guest)
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

Rounding method

Post by cooperds_(Guest) » Tue Dec 31, 2002 4:55 pm

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..

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: Rounding method

Post by kfleming » Tue Dec 31, 2002 5:44 pm

The article http://www.livewarepub.com/ftp/TechDocs/Rounding_Numbers.pdf explains rounding in R&R.____Kathleen__R&R Support

cooperds_(Guest)
Posts: 6
Joined: Tue Oct 10, 2017 12:44 pm

==> RE: Rounding method

Post by cooperds_(Guest) » Tue Dec 31, 2002 6:14 pm

Thanks.. __This helps..

Post Reply