Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
null values in pivot table
3193829
Rank 5 - Community Champion
Hi,
I have a report to display top 10 and other sales. I am using rank on sales and displaying top 10 and others.
the problem is my sales column has null values and the rank is not working for them. When i am selecting a dimension value for which sales has null, instead of top 10 it is displaying all the null values.
i am using ifnull in the column formula of sales(ifnull(sales,0)) but it is not reflcting here. I am trying to do the same from the RPD now.
How do i restrict the sales to display only top 10 even if it has null values or zeros.
Regards,
K
0
Answers
-
Hello,
In the metric of your "data format" try to put this:
#,##0;-#,##0;0
Check this link for more information:
http://total-bi.com/2010/10/replace-nulls-in-obiee-pivot-table/
Kind Regards,
0