Calcul entre deux rows

Ask for Help
2
  • Create a rowID column for your table.
  • Create a lookup column that points to that rowID, you’ll get an array of rowIDs.
  • Use a “find element index” column, find the rowID from the array you created above. You’ll get a list of index for each row, starting from 0.
  • Create a math column and subtract 1 from the index.
  • Create a single relation column linking the math column to the index column.
  • Create a lookup column to get the mileage from the relation.
  • Now you can subtract the lookup mileage from the current row’s mileage using a math column.
2 Likes