5 Replies Latest reply on Oct 25, 2016 3:18 AM by Norbert Maijoor

    How to write if condition across multiple rows

    saijyothi bandagi

      Please see the attached the simple packaged workbook

       

      I need help to calculate the "Original Slot Selected" as a Calculated Field as per following logic:

       

      • For a particular Order Id, if the number of Slot_Change=0, then "Original Slot Selected"="Delivery_End_Time"

      otherwise, if for a particular Order Id, the number of times slot_change>=1, then  "Original Slot Selected" is equal to the "Value Before" for the first occurence of the Slot_Change.

       

      • I am facing this problem as the same Order ID is coming across multiple rows and multiple slot changes.

       

      Also need help to count the number of Slot_change for a particular Order ID.