Discrepancy in rounding on 2 Oracle Forms fields
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?