OTAC/TEE: How To: Use the ROUND Function (Doc ID 1679327.1)

Last updated on OCTOBER 15, 2019

Applies to:

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

Document Purpose:

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
a measure converted to type DOUBLE through a calculation shows the integer value with .00 rather than the actual calculated fraction

Examples:

the original number is -0.006 and when set to two decimal places, it displays as -0.00 rather than rounding up to -0.01
a percentage calculation returns 12.00 rather than 12.58

	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

Goal

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