Calculating the difference between rows

1

Hi All,

I am trying to create a simple fuel tracker, where I log me fuel $/Ltrs and total KMs. For each row I would like to calculate the difference between the current KMs and preceeding row KMs to calculate the KMs travelled as a base for other calculations

An ideas on how to achieve this simply?

2

hi @Andy_Farquharson2 ,

you need to find the preceding value and that is the date before the date on ‘thisRow’.

this required a correctly formated date format. below an example.

in this table the values are already sorted, sometimes you need to sort the table first on dates.

i hope it helps,

cheers, Christiaan

image
image2975×769 152 KB

1 Like
3

Thanks @Christiaan_Huizer , what is the formula that you have in step 01?

1 Like
4

hi @Andy_Farquharson2 , see below.

image
image2518×714 76.1 KB

cheers, Christiaan

1 Like