5 Replies Latest reply: Dec 5, 2017 8:19 AM by Max Maudin RSS

    Value of max Date

    Max Maudin

      Hi,

       

      I Need to Show the Value of Max Date. With the values below the Expression must give as result 58.6 because 02.11.2017 is the "highest" date. How can I get it?

      I tried the Expression below

       

      FirstSortedValue(Value -(Date* 10000 + Value))

       

      but this Expression give me 60 and not 58.6

       

      Any Idea?

       

         

      ValueDate
               57.210.03.2017
                53.47528.10.2017
               58.602.11.2017
               6010.02.2017
               6003.03.2017
               6003.07.2017

               60

      28.07.2017
              60.29.09.2017