If Condition else condition

[KuntalSingh]

I need to applied mention below condition. Can someone please help

1. For Easy cases- [POValue_Category] < 200000 and [Outline Agreement_Status] = "Agreement Not Available" and [Division] = "Marketing

2. For Easy Cases- if [POValue_Category] < 100000 and [Outline Agreement_Status] = "Agreement Not Available" and [Division] is other than Marketing

3. For Medium Cases- [POValue_Category] < 200000 and [Outline Agreement_Status] = "Agreement Available" and [Division] = "Marketing" else Complex cases

 PO Value Purch OrgPOValue_CategoryOutlineAgreement_StatusInvoiceValue CatDivisonComments.

Raw data

 PO Value Purch OrgPOValue_CategoryOutlineAgreement_StatusInvoiceValue CatDivison

3430752	SERV	<50Lac	Agreement_Not_Available	<10Lac	Refinery
204344.5	SERV	<5Lac	Agreement_Not_Available	<1Lac	Refinery
500558.4	SERV	<10Lac	Agreement_Not_Available	<1Lac	Refinery
3430752	SERV	<50Lac	Agreement_Not_Available	<1Lac	Refinery
250279.2	SERV	<5Lac	Agreement_Not_Available	<1Lac	Refinery
250279.2	SERV	<5Lac	Agreement_Not_Available	<1Lac	Refinery
500558.4	SERV	<10Lac	Agreement_Not_Available	<1Lac	Refinery
883376	SERV	<10Lac	Agreement_Not_Available	<1Lac	Refinery
250279.2	SERV	<5Lac	Agreement_Not_Available	<1Lac	Refinery
395856	SERV	<5Lac	Agreement_Not_Available	<1Lac	Refinery
1326000	SERV	<50Lac	Agreement_Not_Available	<1Lac	Refinery
581065.5	SERV	<10Lac	Agreement_Available	<10Lac	Marketing
581065.5	SERV	<10Lac	Agreement_Available	<10Lac	Marketing
581065.5	SERV	<10Lac	Agreement_Available	<10Lac	Marketing
352022.6	SERV	<5Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
562930.7	SERV	<10Lac	Agreement_Not_Available	<1Lac	Marketing
4973617	SERV	<50Lac	Agreement_Available	<50Lac	Marketing
1415519	SERV	<50Lac	Agreement_Available	<50Lac	Marketing
18776.8	SERV	<1Lac	Agreement_Not_Available	<1Lac	Marketing
19470	SERV	<1Lac	Agreement_Not_Available	<1Lac	Marketing
2.5E+08	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
2.5E+08	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
2.5E+08	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
50307711	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
50307711	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
2.92E+08	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
2.92E+08	NHVT	1Cr & above	Agreement_Available	<50Lac	Marketing
23010	SERV	<1Lac	Agreement_Not_Available	<1Lac	Marketing
19682.4	NHVT	<1Lac	Agreement_Not_Available	<1Lac	Marketing
22007958	SERV	1Cr & above	Agreement_Not_Available	<10Lac	Refinery

[dufoq3 · Accepted solution]

Hi @KuntalSingh, you've mentioned Easy cases twice, but without any expected result. 

Check this logic: