Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rounding value to nearest multiple

K.A.SSep 26 2019 — edited Sep 30 2019

I have a value that always needs to be rounded to a nearest multiple, usually 4 or 6 (based on another value). We usually deal with values in the hundreds, but this number must always be rounded to a multiple. As data entry is manual, this often gets messed up.

Is there a way to automatically round the number up, on submit? Or even better, is it possible to have a dropdown appear under a number field that will show the rounded up number as a user types, so that they can click it?

Think, someone ordering a bunch of individual items, that come in bundles of 4, or 6.

Comments
Post Details
Added on Sep 26 2019
8 comments
2,219 views