3 Replies Latest reply: Aug 13, 2018 8:16 AM by Manikantan S RSS

    Max Function when there are Identical Values

    Manikantan S

      Hi All,

       

      Have the below data:

       

      ID

      2

      4

      4

      6

       

      Max(ID) returns 6

      Max(ID,2)  returns 4

      Max(ID,3) returns 2 --> But i want it to return 4 since there are 2 4's. Anyway i can tweak the function to get this output?

       

      Yours Truly,

      S.Manikantan