how to change my expression for multi-selection possible

[vengadeshpalani]

hi all

I have the expression like

= if ((KPI_Flag ='GF' or (TimeSpecial_1<>0 and DueDate>= MonthEnd and  DueDate_1<>0)) and (Match(GetFieldSelections(MapColorSelection),'All','Green')),'Green',

if (KPI_Flag = 'YF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (Match(GetFieldSelections(MapColorSelection),'All','Yellow')) , 'Yellow',

if(KPI_Flag='RF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (Match(GetFieldSelections(MapColorSelection),'All','Red')),'Red')))

when I select Green it select only green value in the table

but when I select more than one value in list box this expression not working

how can i change this in expression level?

[sunny_talwar · Accepted solution]

Try WildMatch instead of just Match

= if ((KPI_Flag ='GF' or (TimeSpecial_1<>0 and DueDate>= MonthEnd and  DueDate_1<>0)) and (WildMatch(GetFieldSelections(MapColorSelection),'*All*','*Green*')),'Green',

if (KPI_Flag = 'YF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (WildMatch(GetFieldSelections(MapColorSelection),'*All*','*Yellow*')) , 'Yellow',

if(KPI_Flag='RF' and (TimeSpecial_1 =0 or DueDate<MonthEnd or DueDate_1=0) and (WildMatch(GetFieldSelections(MapColorSelection),'*All*','*Red*')),'Red')))