Good Day,

Looking to subtract a running total collected daily from the previous total to give me the value used since the last entry.

Better explanation (I hope)

Jan 1 my total is: 1111

Jan 2 my total is 1112, so Jan 2 total - Jan 1 total = 1

Jan 3 my total is 1115, so Jan 3 - Jan 2 total = 3

The running total is kept in the same Column/Field and I want the next Column/Field to auto-calculate the difference from day to day.

In excel: Cell B2 I would use =A2-A1

Cell B3 would be =A3-A2

and so on and so on forever since the total never stop rising.

Clear as mud i hope. I’m likely just overthinking it, and not seeing the whole picture. Airtable is new to me, but if I can get this to work, it will be perfect for our needs.

Thanks,

Marc