You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Seeking solution to avoid roundup in Oracle forecast calculations.

We are aiming to achieve an integer value for the output of 'Final Bookings Forecast'. However, when using the expression round(custom_measure, 0), Oracle is performing a roundup, which results in an unacceptable difference for us.
For example, 5000 is being rounded up to 5032, whereas the acceptable value is 5000 due to the presence of a few high-cost items in the inventory.
How can we resolve this issue?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!