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 |
Solved! Go to Solution.
@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)
Here's an alternative:
([Balance sheet]>=20)+([Turnover]>=40)+([No. of employee]>=250)<=-2