This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

To Creat a simple app in AppSheet

Posted on 10-30-2022 05:37 AM
Prembahadursnd
Bronze 3
Bronze 3
Reply posted on --/--/---- --:-- AM

Prembahadursnd_0-1667133293278.png

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

Solved Solved
0 3 126
Topic Labels
Jump to Solution
0 Likes
2 ACCEPTED SOLUTIONS

Posted on --/--/---- --:-- AM
dbaum
Gold 4
Gold 4
Reply posted on --/--/---- --:-- AM 
SUM(SELECT(TableName[Amount], [_ROWNUMBER] <= [_THISROW].[_ROWNUMBER]))

View solution in original post

Jump to Solution

Posted on --/--/---- --:-- AM
dbaum
Gold 4
Gold 4
In response to Prembahadursnd
Reply posted on --/--/---- --:-- AM

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.

View solution in original post

Jump to Solution
3 REPLIES 3
Top Labels in this Space