1 Reply Latest reply: Sep 21, 2018 2:09 AM by Muniyandi Vasimalai RSS

    How to get string column value based on two column Max of value (Expression)

    Muniyandi Vasimalai


      Hi Team,

       

      i want to get Mac_Code column  value based on max of value of two column (VAL1,VAL2) in Text box expression.

       

      Condition: first we have to consider VAL1 column Max of value then VAL2 column max of value.

       

      Expecting Result is Mac_Code Value = E.

       

      i have tried using FirstSortedOrder function some case max of value in VAL1 column repeated the same value ,this case i'm getting NULL.

       

      Sample Data:

       

                           

      Mac_CodeVAL1VAL2
      A794300
      B454800
      C1003800
      D99.914000
      E1004100
      F895000
      G99.12300
      H971020
      I1003950
      J95.342500
      K1002700