looking for some examples on how to achieve the following using powerapps
I want to have a column in my sharepoint list data source that has a value that is calculated on a decreasing basis.
It's not created yet so I don't have the exact column/field names but it would work like this
Sharepoint List Columns
Row1 StartingValue: 100 SpendValue: 60 RemainingValue: 40 That part is easy LOL however when the next item is added (and it will only ever be SpendValue added) I want the starting value of the new row to be the Remaining value on the previous row... hope you can follow what I mean
Really no clue how to go about this? Do I use a gallery? to display and then a form to udpate? that seems to make the most sense but how do I tell the calculation to use the last row as it's starting value?
I may be over complicating this and there may be a very simple way to achieve it so any advice greatefully received
TIA
