david gabra
Member
Hi
I have added a file showing the flight costs different bands (ranking in Org) - column G
I have the travel start date - column B
and the cost of the flight - Column G
I want to know an exception, which would be defined a where the cost of flight for a given rank (column G) is more than 30% of the average, for a FLIGHT THAT OCCUR IN THE SAME PERIOD, and this must be done per band, and add an complication is that it must be for the location LEAVING LOCATION, when doing the analysis
I hope I have been clear and I have added a file to hopeful make it clearer and to update.
I basically, want an analysis of bands, who flew during the same period, and from the same location, and where one charged a very high fare, and to highlight the suspicious ones.
Please can someone help.
I have added a file showing the flight costs different bands (ranking in Org) - column G
I have the travel start date - column B
and the cost of the flight - Column G
I want to know an exception, which would be defined a where the cost of flight for a given rank (column G) is more than 30% of the average, for a FLIGHT THAT OCCUR IN THE SAME PERIOD, and this must be done per band, and add an complication is that it must be for the location LEAVING LOCATION, when doing the analysis
I hope I have been clear and I have added a file to hopeful make it clearer and to update.
I basically, want an analysis of bands, who flew during the same period, and from the same location, and where one charged a very high fare, and to highlight the suspicious ones.
Please can someone help.
