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

    FirstSortedValue multiple dates

    Tom Hovens

      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?