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 !
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)
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.
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.
Thank you. It woked..
