Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try something like the following,
Sum({$<FIELDTOSEARCH={'*$(=Only(FIELDWITHSELECTEDVALUE))*'}>}Sales)
I hope this helps.
Thanks
Nick