How to retrieve the 2nd largest value?

Discussion created by veritasac on May 30, 2016
Latest reply on May 30, 2016 by beverly

In Excel the formula is: =LARGE(E4:E9;2)


I can do the maximum formula Max(field{;field...})


But in FM how do I achieve returning the 2nd max value like the Excel formula?


Thanks for any help.