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

    Lookup field between rows with max value


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

      accountnamecodevalueMax Value Y/N


      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.