Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How do i count contents of a multiselect field

Highlighted
patrick-sa
Regular Collector

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
Frequent Visitor

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.

//Add this to "OnDomLoad" event