Oracle BI Publisher Reports Round Negative Values Up To the Next Higher Value, Instead Of Rounding To The Next Absolute Value (Doc ID 2061205.1)

Last updated on OCTOBER 02, 2015

Applies to:

BI Publisher (formerly XML Publisher) - Version 11.1.1.6.x to 11.1.1.9.0 [Release 11.1]
Information in this document applies to any platform.

Goal

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).

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms