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))),
Sum({1<Question={"Statistics*"}>}Response)
,Null()))),Company,Year)))
Thank you!