Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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'))
Try this
Pick(WildMatch(GetFieldSelections(names_list, ',',100),'*Trends*', '*Overlap*', '*Overlap*Trends*'), 'Failure', 'Success', 'Success and Failure')
Celambarasan
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.