veritasac

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.

Outcomes