How to reference a pervious row in a Math calculation

  • Start by adding a RowIndex to your table by following the second method described here.
  • Add a Math column that subtracts 1 from the RowIndex
  • Add a Single Value column. It should target your table and take the N from start Meter Reading value, where N is the Math column.

Here is how that would look:

3 Likes