Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
See attachment. QVD atttached too
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))
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))
It works!! Thanks!