My Oracle Support Banner

Data Visualization Calculation Column Using Count Function Displaying Wrong Results (Doc ID 2713044.1)

Last updated on SEPTEMBER 23, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version to [Release 12g]
Information in this document applies to any platform.


In OBIEE Data Visualization (DV), calculation column is displaying wrong results when set the column formula with count(Column) function. This issue can be reproduced by the following Steps:

1. Create a new Project in DV.

2.Create Data Set by uploading the following excel file data and add to the project.

3.Right click on "My Calculations" and select Add Calculation..

4.Add new column named "TestCol", and set formula to: COUNT(CATEGORY).

 5.Click Save button.

6.Click on "Visualize" tab.

7.Add all the columns to a table or pivot.

8.Then can see the wrong results in column "TestCol" is displaying as below:

The product expected results should be as below:


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.