Sum([# Departures Performed]) / Sum(TOTAL <[Carrier Group], Airline> [# Departures Performed])

[dhavalvyas]

I have used this expression,can any one explain how it works in detail ???

[neha_shirsath]

Hi Dhaval,

its give you the output for -

sum of departure performed/ sum of total of departure performed with respect to carrier group and Airline.

[sunny_talwar]

I think the numerator is easy to understand, I think you want to learn about the denominator part, isn't it? I think this might be a good link to start with

The Aggregation Scope

In the denominator, you are suming # of departures performed but you want to get the total of Carrier Group and Airline. So if you had data like this

Carrier Group    Airline    Flight Number    Departures          Sum(TOTAL <[Carrier Group], Airline> [Departure])

ABC                    KLM              123                  10                        50

ABC                    KLM              985                  30                        50

ABC                    KLM              235                  10                        50

ABC                    BA                256                  20                        110

ABC                    BA                425                  80                        110

ABC                    BA                236                  10                        110

CDE                    LLM              223                  30                        55

CDE                    LLM              245                  10                        55

CDE                    LLM              652                  15                        55

CDE                    UA                112                   60                        90

CDE                    UA                542                   20                        90

CDE                    UA                254                   10                        90

So, essentially the TOTAL Qualifier told your expression to sum the value where Carrier Group and Airline are the same and show it in totality everytime it appears

[dhavalvyas]

Thank You so much neha

[dhavalvyas]

Thanx Sunny for give better example for it