My Oracle Support Banner

How To Remove ‘0’ Percentages From OTBI Analysis (Doc ID 3028559.1)

Last updated on JUNE 24, 2024

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.24.04.0 and later
Information in this document applies to any platform.
zero percent
0 percent
zero %

Goal

How To Remove ‘0’ Percentages From OTBI Analysis

EXAMPLE:

Created an OTBI Dashboard report.

Used a seeded measure and union to get the counts as the data is captured in 2 Descriptive Flex Field/DFF columns and looking for cumulative sum of the counts.

Counts are coming to 2 DFF fields (development program participant 1 and 2).
Hence, created a report with union and getting the counts and total using seeded measure.

 


The graph is showing 0% for the null data.

 

 

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.