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

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.

0 1 50
1 REPLY 1

see original post

Top Labels in this Space