Max Year within AGGR Expression

[aliyoung92]

Below is not working and is showing the 'Expression OK' message, however there is a error underscore between the end of the set analysis } and ,

=Sum(Aggr(Avg({<YEARCALC=$(=Max(YEARCALC))>},[Number attended]),EventID,PREVINSTNAME))

I'm presuming there is an error with the syntax but not sure how to fix.

Thanks in advance

[Anil_Babu_Samineni · Accepted solution]

May be this?

=Sum(Aggr(Avg({<YEARCALC={"$(=Max(YEARCALC)"}>} [Number attended]),EventID,PREVINSTNAME))

[aliyoung92]

Thank you