My Oracle Support Banner

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


  • 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

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