Issue: Need to Exclude MonthName Selection in Expression

[sachin1]

I want to exclude the MonthName field in the expression below. It's not working as expected — I want the selection of MonthName to be ignored, meaning the expression should not respond when MonthName is selected.

Count({< [Year-Month]= {"$(vMinMonth)"}, MonthName=,
ID = {"=Not Match(Concat(DISTINCT {<[Year-Month] = {'$(vMaxMonth)'}>} ID, ','), ID)"}
>} DISTINCT ID)

[marcus_sommer · Accepted solution]

The adjustment of the selection state needs to be applied within all expression-parts - means also within the concat(). Also you may look to replace the concat() approach with an e() or p(), maybe something in this way:

Count({< [Year-Month]= {"$(vMinMonth)"}, MonthName=,
ID = e({<[Year-Month] = {'$(vMaxMonth)'}, MonthName= >} ID) >} DISTINCT ID)

Further check if the variables are responding on any MonthName selections.