Match function not working

[#1]

Hi,

I have the following expression:

=if(match(chr(39)&'07-Senior'&chr(39),chr(39) & Concat(distinct [Student Level], chr(39) & ', ' & chr(39)) & chr(39)),1,0)

Where, Student Level has multiple values, like 07-Senior, 01-Junior and so on. If I select 07-Senior alone as the Student Level, the ablove expression returns 1. But, if I select 07-Senior and 01-Junior, the above expression returns 0, where as it has to return 1.

Please suggest!

[#2]

Hi,

Could you upload a sample if possible?

Thanks!

[sunny_talwar · Accepted solution]

Try this instead

=SubStringCount(Concat(DISTINCT '|' & [Student Level] & '|', ', '), '|07-Senior|')

[#4]

Thank you Sunny. Can you explain me why the expression in the question was not working?