Forum Discussion

KatherineOakey's avatar
Qrew Member
3 years ago

Tips and/or tricks to get complex filters in the correct order and grouping

I have a number of fields I want to filter on in a report.

I know how to use and/or and parenthesis to group and filter as I want.

I have fiddled with the filters in this report repeatedly and it seems the biggest challenge is that as I add conditions, figuring out how to get the all/any (and/or) grouping correctly is such a challenge.

Seems like when I add in a new condition, I can't figure out how to get that condition evaluated as I want to sometimes without having to re-add other fields.

Are there any good tips or hints on how to get a complete set of filters/conditions set up in a report?

Katherine Oakey