To Creat a simple app in AppSheet

[Prembahadursnd]

I want to put a formula in Balance column. It is Balance - Amount. How can I do it?

[dbaum · Accepted solution]

SUM(SELECT(TableName[Amount], [_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]))

[dbaum · Accepted solution]

SUM(SELECT(TableName[Amount], [_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]))

[Prembahadursnd]

Now, My formula is - SUM(SELECT(Balance[Amount], [_ROWNUMBER<=[_THISROW]-[ROWNUMBER]))

But, what is the meaning of - [_ROWNUMBER<=[THISROW]-[ROWNUMBER]. Please, explain sir.

[dbaum · Accepted solution]

From the Balance table, select the Amount value from the rows where the row number is less than or equal to the number of the row within which the expression is being calculated.