Eligibility check help

[Navya08]

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.

[DavidSkaife · Accepted solution]

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

[binuacs · Accepted solution]

@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