How to exclude filter in a AGGR expression.

[eddywong71]

Hi All,

This expression work fine if the use don't select Month filter. However if the user select the filter the result is not correct. I think i dont really understand which part cause the problem. I am sure the  {"$(vLastYearEnd)"}>} is correct 

sum(Aggr(MAX({$<Month = {"$(vLastYearEnd)"}>}

Apple, Group ID))

For example :  Default the Dec 2022 result should be 50. If the user click the Month filter maybe 40 ,30 . 

Apple  =(1,0)

[Mark_Little · Accepted solution]

Try

sum({$<Month = {"$(vLastYearEnd)"} Aggr(MAX({$<Month = {"$(vLastYearEnd)"}>}

[eddywong71]

Hi Mark_Little,

Thx so much.