3 Replies Latest reply: Jun 21, 2018 10:51 AM by Rohit Thete RSS

    Aggr Function Help

    Rohit Thete

      Reschedule-Route Example.PNG

       


      I am trying to flag '1' when there is Operation/Transaction of  "Reschedule or Route" for the first time in a given Task ID (as shown in the above) and then sum the number of such records for each LockedBy_IR in separate column.

       

      In the above example, the sum for TGARCIA should be 1 and 0 for rest of the LockedBy_IR.

       

      Any help will be really appreciated.

      Thank you in Advance.