2 Replies Latest reply on Sep 7, 2016 4:35 PM by Patrick A Van Der Hyde

    Calculating difference of data in same column to use for calculatedfield

    Phillip Typaldos

      I am trying to calculate the difference between rows in data to use for a calculated field. The data column is data with a running total that changes over time, I need to know the difference between rows (change) row to row and use that number as part of a calculation for a calculated field. This table shows what I have and what I need:

       

      Time

      Output

      difference (what I need)

      10am

      3

      3

      11am

      7

      4

      11:30am

      8

      1

      12pm

      11

      3

       

      I have also attached the workbook for what I am trying to accomplish which is in the performance tab. I need the output field to be this difference