13 Replies Latest reply: May 12, 2016 5:53 AM by Manish Kachhia RSS

    FirstSortedValue multiple dates

    Marco van Zand

      Hi All,

       

      I want to create a function to calculate the days with the highest occupancy. Till now I have

       

      FirstSortedValue(Datum,-Aggr(sum(Occupancy),Contract)). But when there are mutliple dates with the highest occupancy this function doesn't work. How to solve this?