IF statement with GetFieldSelection

[#1]

Hi

I am trying to create an IF statement where a GetFieldSelections [YearSmall] includes '14/15' .

This seems straight forward when the GetFieldSelections is equal to '14/15' as below

=IF(GetFieldSelections(YearSmall) = '14/15' or GetFieldSelections(Year) = '2014',30)  but this does not then work if multiple selections are made on [YearSmall]

Many thanks

[yduval75]

If(index(GetFieldSelections(YearSmall), '14/15')) > 0

[MK_QSL]

=IF(SubStringCount(Concat(Distinct GetFieldSelections(YearSmall),'|'),'14/15') or SubStringCount(Concat(Distinct GetFieldSelections(Year),'|'),'2014'),30,'')

[SunilChauhan]

=IF(GetFieldSelections(YearSmall) = '14/15' and GetFieldSelections(Year) = '2014',30)