Forum Academy Marketplace Showcase Pricing Features

Two conditions in an advanced filter

Hey everyone!

I’m filtering a list using “Advanced”. The conditions of this Advanced filter are :
A>C AND A<D “OR” B>C AND B<D.
My requirement is that either A or B should lie in between C and D.

Is my way of writing this condition wrong?

Looks correct but if it is not giving you the results you are looking for then you can simplify it maybe by setting custom yes/no states to stateOne = A > C AND A < D and stateTwo = B > C AND B < D. Then in the Advanced just put stateOne OR stateTwo.

2 Likes

This topic was automatically closed after 70 days. New replies are no longer allowed.