4 Replies Latest reply on Feb 8, 2019 5:28 AM by Thanushree Sampangi Pushpa

    Calculated Field

    Thanushree Sampangi Pushpa

      Here is my question

      I have an orderid with sequence, procedure step, and step status.

      I'm trying to find out if the last procedurestep with sequence '9999' has a stepstatus "not started", how can I display the details of the step before that.

      In the example image provided as the status of sequence with 9999 is not started I'm trying to dispaly the line above it  with sequence '1255'

      Notes:-

      - Only the last sequence is a constant 9999  all the other numbers before that change with different orderid

      - in the example provided the step before 9999 also has a status not started in that case i'm trying to display the step before the not started step in a orderid

       

      included a excel for reference