Complicated issue

[Kirsten]

See attachment. QVD atttached too

[fosuzuki · Accepted solution]

If I understood correctly, try replacing the "3.1" with:

avg({<Market={"FRA","AFI","BNL"}>} total <FCO> aggr({<Market={"FRA","AFI","BNL"}>} Sum({<Market={"FRA","AFI","BNL"}>}[Sum of Total Sum of Hours [ITM]]])/Sum({<Market={"FRA","AFI","BNL"}>}[Count of EQ ID]),FCO,Market))

[Kirsten]

It works!! Thanks!