6 Replies Latest reply: Aug 1, 2017 12:16 PM by Tim Kendrick RSS

    Concatenate Results if FirstSortedValue is a Tie

    Tim Kendrick

      I have a text box with the following formula in it:

       

      FIRSTSORTEDVALUE([Response Text],-AGGR(COUNT({<[Question ID]={'1'}>} [Response Text]),[Response Text]))


      Which returns "Honesty" when there is a single value as the max.

       

      Response TextCount

      Honesty

      13
      Bravery11
      Reliability8

       

      But returns null ("-") when there is a tie at the top.

       

      Response TextCount
      Honesty13
      Bravery13
      Reliability6

       

      How can I make the text box return something like "Honesty, Bravery"?