Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])
Count({$<[EMPLOYEE NAME]={"*Mr*"}>}[EMPLOYEE NAME])
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
Count({$<[EMPLOYEE NAME]={"*Mr*"}>}[EMPLOYEE NAME])
Try this
Count({<[EMPLOYEE NAME]={"=WildMatch([EMPLOYEE NAME],'*MR*') > 0"}>}[EMPLOYEE NAME])
Try
Count({<[EMPLOYEE NAME]={"$(=WildMatch([EMPLOYEE NAME],'*MR*')) "}> }>}[EMPLOYEE NAME])
It worked Than you very much for your suggestion