Virtual column need to add "10" itself each day without losing its previous value

AppSheet AppSheet Q&A
1

Please give me the formula of this logic and i can structure it by using your way. Logic: Virtual column needs to add itself number “10” eachday without losing its previous value. and minus ( sum of this column: [ Expenses] (which contains daily expenses). If today’s all expenses sum value is 5 then show me Today: 5 (bcs 10-5), Tomorrow: 15 (5+10), Aftermorrow: 25 and etc. Mine is losing its previous value and calculating the formula again.

And how i can add number 3 to this column (contains this formula) not to expenses column (i can add expense form another table). If i add this 3 to this formula by doing arithmetic, it will calculate this everday but i need to add this 3 for one beggining time that’s it.

2

I don’t completely understand what you are trying to calculate but of what I do understand … you cannot do this with just a Virtual Column. Virtual columns do not store values. Once the app is closed, the state of the Virtual Columns for THAT device are gone. Then there needs to be some way to re-calculate and get back to the expected value. So you need to construct an expression that can calculate the value for the row each time the expression is triggered. This usually means storing all the pieces to perform the calculation into columns in apps.

For example, you wish to add 10 each day. This means that the calculation will need to KNOW the starting date and then determine the number of days from that date to today and multiple by 10 to add to the {Expenses Sum]. That expression might look like:

[Expenses Sum] + ((Today() - [Start Date]) * 10)

For your second part , to add “3” once, you could hard code that into the expression like this:

[Expenses Sum] + 3.0 + ((Today() - [Start Date]) * 10)

If it is something that needs to change regularly or is derived for each row, then you may need to store it somewhere as well - maybe call it [Expenses Adjustment]. The expression then would look like:

[Expenses Sum] + [Expenses Adjustment] + ((Today() - [Start Date]) * 10)

NOTE: that a Virtual column is computed each time a Sync is performed.