3 Replies Latest reply on Oct 30, 2018 6:54 PM by Shinichiro Murakami

    Calculating difference of a field between adjacent rows

    Dian Jiao

      I wonder if there is a way to calculate the difference between current row and previous row for the same field. Attached is the workbook. I have two columns insert_ts and ctrlr_cycle_cnt. The rows are ordered by insert_ts descending. I want to add a third column which calculates the difference between ctrlr_cycle_cnt of the current row and that of the previous row (last timestamp).