Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculating water usage from current and previous record

Topic Labels: Base design
400 2
Showing results for 
Search instead for 
Did you mean: 

I have a table with a date and numeric field. It tracks a water meter reading. Is there any way that I can calculate usage by taking the current record meter reading and comparing the difference between that and the previous records meter reading then calculating the number of days difference between the current and previous record to come up with a litres usage per day?

Thanks in advance.

2 Replies 2

Yes, but the only way I know of doing this is with a script block.

Thanks - I feared that.