Calculate total in a balance sheet

[JHConsulting]

Does anybody know a way to calculate the total in a balance sheet. I mean to add or substract a number from the nube rof the row above, like in a balance sheet.

[Paul_Danyliuk]

You mean calculating the running total?

Referencing the cell above

Nice! I wrote something related here:

[JHConsulting]

Yes, I mean the running total.

[Johg_Ananda]

An example would be very helpful here, it’s hard to know what you’re trying to do.

[JHConsulting]

It is about referencing a cell in the row above.

[Johg_Ananda]

@JHConsulting that makes sense to you as a human, but ‘the row above’ can mean lots of things in a relational database, esp with filters, sorts and views.

[Paul_Danyliuk]

But I replied with a link to the solution in my answer above

Referencing the cell above

Sometimes you need to implement iterative calculation where a value in the next row depends on the value in the previous row (e.g., interest calculator). To do this in Excel / Sheets, you simply reference the cell above by specifying the row as current row index minus 1. In Coda, though, there is no concept of “cell reference” or a ready-to-use row index, and if you try to enter the formula for Value column as =Value.Nth(…), you will get a circular reference error. Solution? — Construct someth…

and Shishir’s reply there too (he does it better by separately looking up the previous row, then using its value)

[JHConsulting]

I have seen it. This answers my question. Thank you.