Set analysis

[chibi]

Can someone tell me where I am going wrong on this? 

=Avg(Aggr(Sum({<Year = {'2021'}>},tkt_amt))-Sum({<Year = {'2021'}>}, cancellation_amt),Date))

[MayilVahanan]

Hi

Comma is there near set analysis, please remove it. Try like below

=Avg(Aggr(Sum({<Year = {'2021'}>}tkt_amt)-Sum({<Year = {'2021'}>}cancellation_amt),Date))