Subject: Referencing Previous Month's Data Posted: 6/30/2019 Viewed: 2435 times
I am trying to calculate surplus water level in tank, which would be equal to previous month's total data added up with the current month's data.
e.g. Tank level (month) = surplus water (month) + Tank level (month-1))
i.e. Tank level (Feb) = surplus water (Feb) + Tank level (Jan)