I’m trying to build a tool to track my personal spendings and incomes. For that one of the things I want to know is how much cash I’m currently have left to spend (in total, not monthly).
I have a Expenses table and Incomes table were I regularly add the expenses with the date the payment was done. I do the same with Incomes, on a separate table. I also created formulas Start Date (The first day where the system started to run) and Today (“Today()”).
I thought of a possible solution to this dilema could be by creating filtered views of those tables, filtered by a date range between Start Date and Today, and then making a formula with a substraction between the sum of the values from the filtered Expenses table and the sum of the values from the filtered Incomes table.
I was unable to do this in code. Can someone help me with this?
Also, if you have a better approach to this solution please feel free to include it.
Thanks in advance!