Subtract fuel usage reading from previous entry

AppSheet AppSheet Q&A
1

Hi,

i have this sheet where i record Fuel usage reading from my generator daily.

i wish to subtract todays reading from yesterday reading to get my usage

what formula can i use?

2

Assming its one table and there is only one generator then you’re simply asking for data from the previous row:

[Fuel Useage]
-
ANY(Select(TableName[Fuel Useage],[_Rownumber]=[_ThisRow].[_Rownumber]-1))

Simon, 1minManager.com

1 Like
3

([this row]. [Fuel Reading] - LOOKUP(([this row].[Date]-1), “YourTableName”, “Date”, “Fuel Reading”))

Replace your column names accordingly

4

works like a charm.. thanks for the swift response.

1 Like