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.

You mean calculating the running total? [image] Referencing the cell above Tips and Hacks Nice! I wrote something related here:

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

It is about referencing a cell in the row above.

@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.

But I replied with a link to the solution in my answer above :confused: [image] Referencing the cell above Tips and Hacks 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 calculato…

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

Calculate total in a balance sheet

Paul_Danyliuk May 2, 2020, 3:27pm 2

You mean calculating the running total?

Topic		Replies	Views
Running total column based on value in previous row	8	2979	July 7, 2021
Get a row by its Id on table	1	2198	July 19, 2019
Reference the previous rows values to calculate incrementally	1	755	August 20, 2021
Referencing the cell above Tips and Hacks	43	23358	November 4, 2023
Running Total (Sum, Average, Median, etc)	10	7186	April 19, 2022

Calculate total in a balance sheet

Related topics