5 Replies Latest reply: Apr 22, 2015 11:08 AM by Stuart Frew RSS

    Calculate a leading record

    Stuart Frew

      hi all,


      I have attached a sample data set to assist with my question.


      Within my data set there are following fields:-


      • Ruleset_ID
      • Reporting_Order
      • CODES


      For each CUSTOMER_ID and Ruleset_ID a CUSTOMER_ID may have multiple codes.


      I want to create a flag which highlights the record that has the smallest number in Reporting_Order.


      In the attached sample data set I have also given a dummy answer.


      Do I need to use the PEEK function to do this? I dont have much experience with that function yet.