Eligibility check help

Question

I have this data i want to flag the ones which are not meeting this criteria:

geography type: domestic

then cabin class should be economy/coach class or premium economy class

and if geography type is international:

then cabin class should be business class or first class.

Eligibilty.xlsx

davidskaife · Accepted Answer

Hi @Navya08

This formula in a Formula tool will work:

IF [Geography type] = "domestic" and [Cabin class] in ('Economy/coach class','Premium economy class')
THEN 0
ELSEIF [Geography type] = "International" and [Cabin class] in ('Business Class','First class')
THEN 0
ELSE 1
ENDIF

binu_acs · Accepted Answer

@Navya08 another way of writing the expression

IF ([Geography type] = "Domestic" AND NOT ([Cabin class] = "Economy/coach class" OR [Cabin class] = "Premium economy class"))
OR ([Geography type] = "International" AND NOT ([Cabin class] = "Business Class" OR [Cabin class] = "First class")) 
THEN "Invalid"
ELSE "Valid"
ENDIF