Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm stuck!
I'm trying to add a reference line to my graph. The equation below works great when I want to include all CompanyIDs.
= (Avg ( {1<Year = {$(=Max(num#(Year ,'####',)))}>} Total Aggr(
(Sum ({1<Question={"Financial*"}>} Response),
CompanyID, Year)))
However, when I only want to use CompanyID = (<11 and >20), I can't figure out how to write that and where to put it! I can exclude it from my graph, but I can't exclude it from the average calculation for my reference line.
Please help! Thank you.
May be try like this
= (Avg ( {1<Year = {$(=Max(num#(Year ,'####',)))},CompanyID={'<11>20'}>} Total Aggr(
(Sum ({1<Question={"Financial*"},CompanyID={'<11>20'}>} Response),CompanyID, Year)))