Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.