Last updated on OCTOBER 02, 2015
Applies to:BI Publisher (formerly XML Publisher) - Version 126.96.36.199.x to 188.8.131.52.0 [Release 11.1]
Information in this document applies to any platform.
To describe the rounding calculations for BI Publisher reports which contain negative numbers in some fields.
BI Publisher reports which contain negative number values seem to round incorrectly, eg. a field with -3.5 is rounded to -3. For some business implementation requirements, when rounding a negative number you round to the next absolute value eg. a field with -3.5 is rounded to -4.
Positive numbers are rounded also rounded to the to the next absolute value, for example 3.5 would be rounded up to the next whole number 4. So why do negative values in BI Publisher round up to a higher numeric value (eg, -0.5 to 0 instead of -1) instead of the next absolute numeric value (eg, -0.5 to -1 instead of 0).
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms