3 Replies Latest reply: Jan 23, 2014 9:15 AM by Nicole Smith RSS

    Getting the ID number from the last row saying: "Started"

      Hey guys, I have a simple question:

       

      SequenceStatusName
      1StartedA
      2StartedB
      3Not StartedC
      4Not StartedD

       

      I want to create a field that says that the current position is "2" (last one started). I tried to use this:

       

      IF(Status=PREVIOUS(Status),'',Sequence) as Current_Position.

       

      The problem with that, is that also counts the headers, so, number "1" always come in this field, and I don't want that, i want simply to show "number 2".

       

      How can I do that?

       

      Thanks