Calculate amount

AppSheet AppSheet Q&A
1

Hello,

message edited below…

I need a formula to calculate amount from previous row column A + this row column B in this row column C this row column B. For example… Colomn A from previous row (row 4) is 3000, I have to calculate (row5) column B is 1000 so in this row column C should be 4000.

i correct this explanation…

the column [new amount] from previous row should be added up with column [ amount] in this row.

SO… row 4 [new amount] is 3000 and this row (row 5) column [amount] is 1000 then colomn [new amount] this row (row 5) should be 4000.

Thx for the help.

2

Try with something like this, but with your own table and column names..
[Amount] +
LOOKUP(
MAXROW(“TableName”,“_rownumber”,[_ROWNUMBER]<[_THISROW].[_ROWNUMBER]),
“TablaName”,“KeyColumnName”,“New Amount”
)

The idea is to read first your latest row (before this newest row) and it’s unique ID. For that purpose is the MAXROW(). Then when you know it, you read the value with the LOOKUP().

3

Thx for the help, it worked but only with a few ajustments and using my brains :grin:

4

Excellent!