Two of the three conditions meet

[akumar2609]

Hi All,

I need some support on the below request. I have three fields and I want the data where at lest two conditions meet out of three.

Legal Entity	Balance sheet	Turnover	No. of employee
1	20	40	250
2	18	45	300
3	15	39	200
4	22	35	299
5	24	10	450
6	18	12	400
7	12	16	100

Criteria:-

Balance sheet -         equals or grater then 20

Turnover -                  equals or grater then 40

No. of employee -     equals or grater then 250

In the above data set, I want those records where at lest two criteria meet.

Required Result:-

Legal Entity	Balance sheet	Turnover	No. of employee
1	20	40	250
2	18	45	300
4	22	35	299
5	24	10	450

[Prometheus]

@akumar2609 Try this expression in a Filter tool: 

([Balance sheet]>=20 and [Turnover]>=40)

or ([Balance sheet]>=20 and [No. of employee]>=250)

or ([Turnover]>=40 and [No. of employee]>=250)

[Christina_H · Accepted solution]

Here's an alternative:

([Balance sheet]>=20)+([Turnover]>=40)+([No. of employee]>=250)<=-2