Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Hide the values of a column in report

Hi All,
I have a report with three columns as Project name, Actual hours & Plan hours. my requirement is I don't want to show the projects where actual and plan hours both are equal to zero. How to achieve this ..
Thanks !
Answers
-
Hi,
If you don't show project with actual hours and plan hours equal to zero, you must create something likt that in filter:
Principle of operation: NOT ( A and
== (NOT A) or (NOT
Or add this two filters with sql:
(Actual Hours <> 0 OR Plan Hours <> 0)
0 -
Hi,
That's how I am not able to understand how to put that in filter. when I am giving like this it's throwing me error.
0 -
Hi,
You past this code in wrong place.
When you click PPM on for exmaple Actual Hours Column and choose Filter, when next you must click Convert this filter to sql and click OK.
And it opens a new windows: Advanced SQL filter and there past code.
And end view:
If I helped, then give the correct answer.
0 -
Thank you. It woked..
Thanks !
0