2 Replies Latest reply: Nov 28, 2013 12:50 PM by Adam Fearnhead RSS

    Return String based on Highest Count

      Hello,

       

      In a text field I want to display the name of a value with the highest count.

       

      So far I have this

       

      =MaxString(aggr(Count({1<[Billable_Status] = {Billable}>}Practice)Practice))

       

      This returns back the highest count of billable employees in a practice, but I want it to display the name of the practice not the count.

       

      Thanks.