Forum Discussion
If Condition else condition
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 |
Hi KuntalSingh, you've mentioned Easy cases twice, but without any expected result.
Check this logic:
1 Reply
Hi KuntalSingh, you've mentioned Easy cases twice, but without any expected result.
Check this logic: