Hide the values of a column in report — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hide the values of a column in report

Received Response
1
Views
4
Comments
3174977
3174977 Rank 5 - Community Champion

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

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    Hi,

    If you don't show project with actual hours and plan hours equal to zero, you must create something likt that in filter:

    pastedImage_0.png

    Principle of operation: NOT ( A and B) == (NOT A) or (NOT B)

    Or add this two filters with sql:

    (Actual Hours <> 0 OR  Plan Hours <> 0)

  • 3174977
    3174977 Rank 5 - Community Champion

    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.

    ob.JPG

  • choracy69
    choracy69 Rank 6 - Analytics Lead

    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.

    pastedImage_0.png

    pastedImage_1.png

    And end view:

    pastedImage_2.png

    If I helped, then give the correct answer.

  • 3174977
    3174977 Rank 5 - Community Champion

    Thank you. It woked..

    Thanks !