4 Replies Latest reply on Jan 4, 2017 2:21 PM by mark.welsh

    Lookup field between rows with max value

    mark.welsh

      Let's say I've got two rows of data in my table:

      accountnamecodevalueMax Value Y/N
      1234joe1234520N
      1234joe5432125Y

       

      I need a way to identify the code with the max value per account and then store that as a Y/N in a new column.  So, the result for the above 2 rows would be Max Value = Y for code '54321' since it's value is the highest. 

       

      Appreciate any help.