Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Stars
Creator
Creator

Syntax Help

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.

1 Reply
settu_periasamy
Master III
Master III

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