WildMatch not working properly

[udaya_kumar]

Hi,

I am using the below expression in table

=IF(wildMatch(GetFieldSelections(names_list),'*Overlap*') > 0,

'Success',

IF(wildMatch(GetFieldSelections(names_list),'*Trends*') > 0,

'Failure'))

I have a list box with many values and the field in listbox is names_list.

if i select single value in listbox, for example, Trends, then it shows Failure.

if i select multiple value in listbox, for example, Trends and Overlap then it shows success in table expression.

its not showing both success and failure.

but how it is taking overlap always, when i select multiple values?

how to resolve this issue?

please somebody help me.

[#2]

try this

=IF(wildMatch(GetFieldSelections(names_list),'*Overlap*') > 0,

          IF(wildMatch(GetFieldSelections(names_list),'*Trends*') > 0,'Success - Failure','Success'),

               IF(wildMatch(GetFieldSelections(names_list),'*Trends*') > 0,'Failure'))

[CELAMBARASAN]

Try this

     Pick(WildMatch(GetFieldSelections(names_list, ',',100),'*Trends*', '*Overlap*', '*Overlap*Trends*'), 'Failure', 'Success', 'Success and Failure')

Celambarasan

[swuehl]

Or maybe

=pick(

wildMatch(GetFieldSelections(names_list),'*Overlap*Trends*','*Overlap*','*Trends*'),

'Success/Failure',

'Success',

'Failure'

)

edit: Sorry, haven't seen Celambarasan's post before. But I think we should test for the combined selection case first.