Hello, I am a user who studies airtable. I would like to inquire about the function of using airtable.
In Excel, a fomula can be calculated by referring to previous row (previous record) values.
So it's easy to implement how to get the following balance, but I haven' t found a way yet in airtable.
No | content | income | spend | balance |
1 | apple | 10 | 10 | |
2 | banana | 20 | 30 (=10+20-0) | |
3 | cherry | 15 | 15 (=30+0-15) | |
4 | hotel | 5 | 10 (=15+0-5) | |
5 | fox | 10 | 0 (=10+0-10) |
I would like to add or subtract this record value to the previous record value so that the cumulative balance comes out.
I asked the same question a few days ago, but I didn't receive the answer I wanted, so I'm requesting it again.
Thanks. Have a nice day.