2 Replies Latest reply on Nov 28, 2018 10:41 AM by Yinglu Wang

    Rank based on calculated field (has duplicates)?

    Yinglu Wang

      Hi everyone,

       

      I have a question about Rank. Is there a way to start ranking based on the values from another calculated field?

       

      I have a calculated field as below:

      Screen Shot 2018-11-28 at 13.10.16.png

       

      I want to have another column called Rank, it should be 1 when cond="start", and the number should be incremental till cond="end".

       

      The result should look like this:

      Screen Shot 2018-11-28 at 13.19.52.png

       

      Any insight will be helpful!

       

      Thanks,

      Yinglu