1 Reply Latest reply on Oct 26, 2016 12:39 AM by Hardik Hirpara

    How to write nested if condition across multiple rows

    saijyothi bandagi

      Hi,

       

      I need help to calculate the "Valid Orders" as calculated field as per the following logic:

       

      For a particular order id, if  the tag = "status change" then  the value_Before = 'INITIATED' and (value_After = 'VERIFIED' or value_After = 'VERIFICATION_FAILED') then it is a valid order as well as tag = "slot change"  then value before = DATE and value_after = DATE  is also a valid order.

       

      I am facing the problem because one order_id is having multiple tag fields they are slot_change and status_change.

       

      Kindly help to get the logic for valid orders.

       

      Please have a look on attached simple packaged workbook.

       

       

       

      thanks.