How to perform itterative calculations?

AppSheet AppSheet Q&A
, , , , ,
1

I have an appsheet view where the user can input the progress and this progress is meant to be added to the cumulative work done. In other words cumulative work done = Enter Progress+ Cumulative work done(previously recorded). My issue is I used the formula :

SUM(SELECT(
Items2[Cumulative Work Done],
([Cumulative Work Done]=[_THISROW].[Enter Progress]+[_THISROW].[Cumulative Work Done])
)
)

Issue is this formula works only when the input on the enterprogress tab is 3 or 6 which is quite weird. Can anyone point out if there is something I am missing?

2

Where are using this formula exactly? and to do what?

3

SELECT() is for retrieving data. The second parameter of SELECT() is a condition that’s checked on all rows, not an action.

https://help.appsheet.com/en/articles/2357314-select

You’ll need to run an action that adds the [enter progress] value to the [cumulative work done] value.

1 Like
4

I am using this formula on the column “Cumulative Work Done” in the auto compute area. The purpose is that when the user enters the progress which is another entry column, the cumulative work done must be updated i.e. Cumulative Work Done= enter progress+Cumulative Work Done (last recorded) and it continuously updates

5

In general speaking I assume you are looking for something like..
SUM(SELECT(Data[Progress],[_ROWNUMBER]<[_THISROW].[_ROWNUMBER]))+[Progress]

With the [_ROWNUMBER] you can be sure the formula also works if you open the record later. If it’s possible that someone will change the progress number from the beginning later, you would need to use a virtual column for this purpose.

1 Like
6

can you please explain me what this formula is doing? When I use this formula the cumulative progress column auto populates some entry to a row where no entry was made before, so when I add a progress it adds it to the older version. My formula is as follows: SUM(SELECT(Items2[Cumulative Work Done],[_ROWNUMBER]<[_THISROW].[_RowNumber]))+[Enter Progress], in the aunocompute section of cumulative progress column. At times it is also editing the quantity which is independent and non-editable

7

I do not understand how to do that within the column? As enter progress is a field editable on a form

8

You should show examples of your data and the desired result.

9

The formula calculates your values before the row and sum them.. and it adds the progress from that row as well.