expression to make daily spent limit based on previous expenses

Hello guys,

i'm trying to build a money saving app.
I'd like to set a daily spending limit based on an amount I'd like to save per month.
So far easy.

In a few words, I'd like to move the savings from the previous day to the next day


I'll explain better with an example:

 

 

Schermata 2023-01-04 alle 03.59.08.png

44,52=22,26 +22,26

Schermata 2023-01-04 alle 03.59.23.png

  66,78=44,52+22,26  and 79,04=66,78+12,26

How can i express with an expression the column "spent limit progressive" in table 2?

Thanks!!

0 1 66
1 REPLY 1

I noticed that the formula in spreadsheet can be simplified like this but i dont' manage to transform this in appsheet expression..

 

Schermata 2023-01-04 alle 15.03.05.png

 

Schermata 2023-01-04 alle 15.03.16.png

Top Labels in this Space