7 Replies Latest reply: Jan 21, 2013 6:47 AM by Jörg Hildebrandt RSS

    find highest value

    Jörg Hildebrandt

      Hi all

       

      Seems my head is not the best today.

       

      I am trying to find the highest value in a table. In this case it is the value in month 10.

       

       

       

      IDMonthValue
      Item017.279.389
      Item027.621.106
      Item037.928.659
      Item048.374.085
      Item057.582.951
      Item068.461.163
      Item078.800.933
      Item088.578.971
      Item098.505.260
      Item109.313.773
      Item119.109.731
      Item128.673.098

       

      The desired result should look like this:

       

      IDMonthValue
      Item109.313.773

       

      I tried with max, but failed.

       

      Can somebody give me an idea for a formula ?

       

      Thanks in advance.

       

      Joerg