12 Replies Latest reply: Nov 14, 2017 7:47 AM by Stijn Valkenburg RSS

    FirstSortedValue Aggr double values

    Stijn Valkenburg

      Hi,

       

      I want to create a textbox in which I want to display the name of the individual whose name occurs most often. To do this I use below expression in which 'name' is the column in which the name of the individual is displayed:

       

      FirstSortedValue(name, -Aggr(count([name]), name))

       

      This generates what I am looking for but as soon as there are multiple names with the same max count, the textbox goes empty, indicating that something goes wrong. Any idea how to fix this?