Oracle Forms (MOSC)

MOSC Banner

Discrepancy in rounding on 2 Oracle Forms fields

edited Jan 13, 2023 4:57PM in Oracle Forms (MOSC) 5 commentsAnswered ✓

I have 2 fields in a form.

Both have a format mask of 99,999,999,990.00.

Both have formula property values.

Field 1 is populated with a function which returns an unrounded value of 3941.87499999998

The value displayed in Field one is 3941.87.

Field 2 is populated with the total of Field1 + Field3 (which is 5000000).

However the output in Field 2 is 5003941.88

Why is the value in Field 2 being rounded up to 5003941.88, instead of being displayed as 5003941.87?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center