Post

2 followers Follow
0
Avatar

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 Answered

Please sign in to leave a comment.

3 comments

0
Avatar

Hi Martin,

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

Yossi Truzman 0 votes
Comment actions Permalink
0
Avatar

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 0 votes
Comment actions Permalink