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



      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.