IF (GetSelectedCount(Year)=1 andMonth(%Date)=Aggr(Max({1}Month(%Date)),Year),Sum(qty))
What I am trying to do is to create column in table that will summarize actuals when specific year selected and Month equal to the highest Month in this year.
If the conditions are not satisfied do nothing.
But when I put this formula in expression I get no result.
I also tried to put Aggr(Max({1}Month(%Date)),Year) as variable but it is still does not work.