AnsweredAssumed Answered

Select the most common value in a text field that is in a list form

Question asked by nuwanG on May 31, 2015
Latest reply on Jun 1, 2015 by nuwanG

Title

Select the most common value in a text field that is in a list form

Post

Hi All,

I have a list of values separated by carriage returns in a text field as below:

Minor

Minor

Moderate

Major

Moderate

Moderate

How do I get the most common value in this list field? It seemed simple when I thought of it but has proven me wrong so far. Hope someone could help out. 

Thanks

Randy

Outcomes