Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
eddywong71
Creator
Creator

How to exclude filter in a AGGR expression.

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)

Labels (3)
1 Solution

Accepted Solutions
Mark_Little
Luminary
Luminary

Try

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

View solution in original post

2 Replies
Mark_Little
Luminary
Luminary

Try

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

eddywong71
Creator
Creator
Author

Hi Mark_Little,

Thx so much.