AnsweredAssumed Answered

Length (text), then get highest value field contents?

Question asked by lindseym on Mar 24, 2017
Latest reply on Mar 24, 2017 by lindseym

I was able to figure out how to calculate the length of a field, and now I want to have it return the actual contents of the longest field, not the character count.

 

If it has two or more instances with the same character count, I want it to show me all unique outcomes only.

 

 

Sub Summary Field                   Text                     Length(text)       

Alpha                                         Apple                   5

Alpha                                         Banana                6

Alpha                                         Banana                6

Alpha                                         Carrot                  6     

Beta                                           Orange                6

Beta                                           Rutabaga            8

 

 

 

What I want to get:

 

Alpha      Banana, Carrot

Beta        Rutabaga

 

Thanks,

-L

Outcomes