My Oracle Support Banner

How to use the ROUND function with Scaled Values in Management Reports (MR) (Doc ID 2646578.1)

Last updated on MARCH 04, 2024

Applies to:

Oracle Enterprise Performance Reporting Cloud Service - Version 17.01.25 and later
Information in this document applies to any platform.


Management Reporting Cell Properties allows defining a Scale Factor to be applied to the value displayed in the cell.  Defining a formula row to apply the ROUND function and then applying a scale factor in the cell properties of the ROUND-ed value can give unexpected results.  For the example below:

This results is a value 1,599.4077 being displayed for the data value.  The expected value rounded to 2 decimal places is 1,599.4100.

In actuality, ROUND is applied to the underlyingl un-scaled value (1,559,407.6683) yielding a rounded value of 1,559,407.67.  After the cell scale factor and decimal display settings are applied, a value of 1,559.4077 is displayed.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.