Checking like condition in expression

[Anonymous]

Hi,

How to check the like condition in expression?

e.g. I have 1 column in which data is like ABC;DEF considering ABC and DEF are 2 different employees.

I have listbox with the employees. Now when user selects ABC from the list box what I am looking for is data only ABC as well as data ABC;DEF should be picked up.

Kind of looking something similar to "like" in SQl. I have tried wildmatch but it doesnt work if we give column name. String has to give in the command.

Thanks.!

--Swapnil

[#2]

Hi,

Try something like the following,

Sum({$<FIELDTOSEARCH={'*$(=Only(FIELDWITHSELECTEDVALUE))*'}>}Sales)

I hope this helps.

Thanks

Nick