topic Re: Complicated issue in App Development

Complicated issue

Kirsten — Fri, 05 Jun 2020 20:40:45 GMT

See attachment. QVD atttached too

Re: Complicated issue

fosuzuki — Mon, 08 Jun 2020 15:34:32 GMT

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))

Re: Complicated issue

Kirsten — Mon, 08 Jun 2020 18:57:39 GMT

It works!! Thanks!