Subtracting in field - Record from Record

[Outside_Operato]

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

[Andre_Zijlstra]

@Tuur
I spent some time trying to apply your suggestions. I do get stuck every time, because of this:
There are only 2 items that are entered manually:

1. The starting time (“00”), and
2. the duration.

Everything else is calculated. And that causes circular references every way I try. Maybe you can go a little deeper in finding a solution? I just don’t find the proper solution.

Regards.

[Tuur]

Turns out I was wrong about linking back in one table. I thought I’d done that in the past… :thinking:

Anyway, you can do it with two tables. It’s not pretty, but it works. If you want to copy the base just let me know. :slightly_smiling_face:

[Andre_Zijlstra]

Thank you @Tuur!! This is what I’ve been looking for.
I would like to have the base, because of the formula’s and the link between tables.

Regards
André

[Tuur]

PM incoming in 5, 4, 3, 2, 1…

[Xemo]

whats the private message for ??! i am trying to do the same. can you share your solution

[Xemo]

@Tuur why PM :slightly_smiling_face: could you tell us your solution

[Tuur]

The solution is already posted. The PM was only for sharing the base.

But I suspect you’d like a link too?

[Xemo]

@Tuur
yes please send me the link to base

[Tuur]

Sure.

You’ve got a PM.

[Xemo]

@Tuur thanks for sharing … i d like to have a good feedback on this, but it is really hard to imagine how we can implement a similar solution in a good scale and production.its un-managable
i really liked airtable but i am constantly hitting walls with limitations of the design.

thanks