How To: Correct Numeric Values to Display as Rounded

How To: Correct Numeric Values to Display as Rounded (Doc ID 1679327.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Taleo Platform Cloud Service - Reporting for OBI - Version 13C and later
Information in this document applies to any platform.

The goal of this document is to provide details on how to convert a calculated measure to appear as rounded where:

the numeric value is set to display a specific number of decimal places but the value cuts off rather than rounds up
- Example: original number -0.006 when set to two decimal places displays as -0.00 rather than rounding up to -0.01

a fact (measure) converted to type double through a calculation shows the integer value with .00 rather than the actual calculated fraction
- Example: percentage calculation returns 12.00 rather than 12.58

	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