2 Replies Latest reply on Jun 1, 2015 4:42 AM by nuwanG

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

    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