Report Filter Advanced Logic - How To Create an Either Or

Afternoon,

We have 2 columns called Project Highs and Project Lows. I have made a report so we can see all of the highs and lows across all projects on the one page.

What I would like to setup is so the report only shows projects that have data in the High's or Low's fields. If both fields are blank, the project is not displayed.

i assume this can be achieved in the Advanced Logic filter, but I have no idea how to do this.

Any assistance would be much appreciated.

Thanks

Martin

Martin Jubb August 27, 2015 10:51 Answered

Please sign in to leave a comment.

3 comments
Date Votes

Hi Martin,

Do you have difficulties with the Syntax of the Advanced Filtering?

Yossi Truzman August 27, 2015 10:58 0 votes

Hi Yossi,

I'm not technical with this kind of issue and so I don't even know where to begin with getting this to work.

Cheers

Martin Jubb August 27, 2015 11:05 0 votes

Hi Matrin,

Please navigate to - https://success.clarizen.com/hc/en-us/articles/206448037-13-3-Creating-a-new-report#creating-a-new-report 2.Click the Hyperlink - Add Filters to a Report 3.There you will see a Toggle to activate "Advance Filter Logic"
In your case since you have an "OR" relation, the Logic will be (A or B) A=Data in High B=Data in Low

Was this helpful?

Yossi Truzman August 28, 2015 06:54 0 votes

Report Filter Advanced Logic - How To Create an Either Or

3 comments Date Votes

3 comments
Date Votes