Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a filter set for Company = A.
When I have this expression as my KPI, the result is 36. Which is perfect.
(Avg({$<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(Sum({1<Question={"Statistics*"}>}Response),Company,Year)))
I want to use this in another equation. But when I nest it, something is wrong....
This, where I type in 36, yields exactly what I want.
=(count({1<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(((if(Sum({1<Question={"Statistics*"}>}Response)>36,
Sum({1<Question={"Statistics*"}>}Response),Null()))),Company,Year)))
But when I try to put my other equation in there for the 36, it doesn't work.
What am I doing wrong?
=(count({1<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(((if(Sum({1<Question={"Statistics*"}>}Response)>
(Avg({$<Year = {$(=Max(num#(Year ,'####')))}>} Aggr(Sum({1<Question={"Statistics*"}>}Response),Company,Year))),
Thank you!