Skip to Content
avatar image
Former Member

Count of Match pattern string in a column

I have following output I need count

EmpId Employee Type

Q12 Assistant;General

Q13 General

Q14 Assistant;NonGenral;General

Here I need output count as from above column

General 3

Assistant 2

Non General 1

Please suggest any solution

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    May 25, 2017 at 09:37 AM

    Found the solution:

    =count([EmpId] where (Match([Employeetype];"*General*")))

    Now you will get the count for general as 3.,like this we have do for other values in column LOV's

    Add comment
    10|10000 characters needed characters exceeded