Hi,

New to Zoho and trying to figure out how to do this.

I have daily records of fluid level for multiple tanks.  For any given tank, I am looking to pull data from the previous days (or could be a couple of days back - last record) for the new entry, so I can calculate the change in levels.

For example

Day 1 - Time 1 - Tank 1 - Level = 5'

Day 1 - Time 1 - Tank 2 - Level = 1'

Day 3 - Time 3 - Tank 1 - Level = 6' (what to calculate 1' of chnage)

 

Any pointers or suggestions?

Thanks,

Chris