topic Issue: Need to Exclude MonthName Selection in Expression in App Development

Issue: Need to Exclude MonthName Selection in Expression

sachin1 — Wed, 23 Jul 2025 06:14:34 GMT

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)

Re: Issue: Need to Exclude MonthName Selection in Expression

marcus_sommer — Wed, 23 Jul 2025 10:27:14 GMT

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.