Wild Match function in Set Analysis

[LP27]

Hi,

I  am not sure how to use wild match within set Analysis.

Here is my case -

Order No	Remark
1	E1;E*,R*
2	E2;E3;E4
3	E1;R1,R*
4	E4;

Now I want to exclude the R values in column Remark. So it should only show row E2;E3;E4 and E4;

Here is what I have tried :-

Count({$<Remark - = {"*R*"}>} OrderNo)

1. Note sure if I have to use single or double quotes to search the string ?
2. Since my Remark Column already contains * with values, will it still be considered doing "*R*" 

Could some one guide me best way to solve this issue.

Thanks in advance!!!

[nisha_rai · Accepted solution]

Hi,

Please use the below condition:

Count(distinct {<Remark-={"*R*"}>}[Order No])

[kaushiknsolanki]

Hi,

It works in my case.

See the image Below.