I'm using 18.2 and have been creating calculated fields for about 6-12 months, but still have problems in some cases.
In this case have fields for Flights (Airline, Departure Airport, Arrival Airport, Airplane Type), Airports (Identifier, City, Country), Regions (Country, Specific Regions (17 in all)).
As you can see in FlightsFromTo workbook, I have the [Airline], [Specific Region], [Departure Airport], [Specific Region], and [Arrival Airport]. I don't want to stack the fields in Rows like this though.
I need to two calculated fields, [Departure Region] with the [Specific Region] for the [Departure Airport] and the [Arrival Region] with the [Specific Region] of the [Arrival Airport]. Then I need to be able to select in two filters for [Departure Region] and [Arrival Region], so I can identify all flight combinations of airports that fly between those two regions. How do I make the [Departure Region] and the [Arrival Region] calculated fields?
When I try IF [Departure Airport], THEN [Specific Region], it expects a boolean value to compare to [Departure Airport]. CASE doesn't work either.
My output would ideally say something like:
Airline Departure Region Arrival Region Dep Airport Arrival Airport Aircraft Type
North America Europe
CHICAGO to LONDON Boeing 787
BOSTON to AMSTERDAM Airbus A380
North America South America
HOUSTON to SAU PAULO Airbus A330
PHILADELPHIA to LIMA Airbus A340
Thank you in advance for your help!!! The packaged workbook is attached.