My Oracle Support Banner

Oracle Talent Acquisition Cloud (OTAC): How To: Use the ROUND Function (Doc ID 1679327.1)

Last updated on JULY 12, 2019

Applies to:

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

Goal

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

 

Solution

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
Solution
References


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