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:-

       

      • CUSTOMER_ID
      • 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.

       

      Thanks

      Stuart