Project and Portfolio Management Practitioners Forum
cancel

How do i count contents of a multiselect field

Highlighted
patrick-sa
Super Contributor.

How do i count contents of a multiselect field

Hi ,

 

I need a way of counting the contents of a multiselect field in our projects.We have a multiselect field that is populated by system names,we want to display the count of occurences for each system.So we need a query that will count the individual occurences of the system for all the projects concerned.Counting for single select values is easy but the problem is identifying and counting the system name when you have multisystems.

 

System name 

 

Fusion = 3

PPFE = 2

 

I have attached the field and validation contents.

 

Thanks,

Patrick.

1 REPLY
kwood55
Honored Contributor.

Re: How do i count contents of a multiselect field

Examine the string functions for your database.

 

In Oracle:

 

REGEXP_COUNT - returns the number of times a pattern occurs in a source string.