Can you 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. Please reply.
2) Btw 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.
LinkedIn
Twitter
