Date Selection is not Working

[Lakshminarayanan_J]

Dear All,

Need a urgent Help on below requirement,

Need to display the data based on  Country and Month Selection .

Below Expression is Working Fine if we Select between = Sep20 to Dec20

Expression:

Scenario 1:

=if(COUNTRY='Italy' and (substringcount(GetFieldSelections(MonthYear),'Sep20, Oct20, Nov20, Dec20')),
round(sum({<BRAND=,PRODUCT=>}WEIGHT)))

Scenario 2(Not Working):

if  User is Selecting the MonthYear from Sep20 to Apr21 is not working for below selection:

=if(COUNTRY='Italy' and (substringcount(GetFieldSelections(MonthYear),'Sep20, Oct20, Nov20, Dec20,Jan21,Feb21,Mar21,Apr21')),
round(sum({<BRAND=,PRODUCT=>}WEIGHT)))

Kindly Help on resolving the Scenario 2 

[stevejoyce · Accepted solution]

It's probably you are missing spaces between commas in your string after Dec20, this should fix it:

,'Sep20, Oct20, Nov20, Dec20, Jan21, Feb21, Mar21, Apr21'

But I would look for another way to do this that's not so string literal dependent.  Maybe:

(getselectedcount(MonthYear) = 8 and min(MonthYear) = 'Sep20' and max(MonthYear) = 'Apr21')