Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
How do we script this challenge? the code below gives "nested aggregation not allowed":
Sum({<[days]={">-6<1"}, [Year]={$(=max([Year]))}>} Count([ID])) / Count([ID])
Thanks for any advice
Tom
You need an aggr() for it. Something like this:
sum(aggr(count(ID), Dim1, Dim2)) / count(ID)
whereby Dim1, Dim2 are placeholder for the dimension in which context the calculation should happens - usually all dimensions from the object.
- Marcus