can any one tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name

[#1]

I would appreciate if you can tell me how to count males based on Value 'Mr. in "ashok, Mr. saini' column name is employee name. I tried but it is returning only 0 value

Count({<[EMPLOYEE NAME]={MR.}>}[EMPLOYEE NAME])

[martinpohl]

Hello,

you can use

Count({<[EMPLOYEE NAME]={'*Mr.*'}>}[EMPLOYEE NAME])

Set Analysis is case sensitive, so if not all values are in same cases, create a field with upper() and change to

Count({<[EMPLOYEE NAME]={'*MR.*'}>}[EMPLOYEE NAME])

regards

[vvvvvvizard · Accepted solution]

Count({$<[EMPLOYEE NAME]={"*Mr*"}>}[EMPLOYEE NAME])

[antoniotiman]

Try this

Count({<[EMPLOYEE NAME]={"=WildMatch([EMPLOYEE NAME],'*MR*') > 0"}>}[EMPLOYEE NAME])

[Anonymous]

Try

Count({<[EMPLOYEE NAME]={"$(=WildMatch([EMPLOYEE NAME],'*MR*')) "}> }>}[EMPLOYEE NAME])

[#6]

It worked Than you very much for your suggestion