I have 3 apps.
1 = account codes (it's how our company assigns expenses to each department)
2 = credit card expenses (has date field)
3 = invoice expenses (has date field)
In the account codes - I have 1 "Money field" for each month of the year so a Director could have their budget spread, i.e.
I would like to calculate the remaining budget subtracting any related expenses to that account code. If I were doing this by the yearly budget, easy peasy - I'd just put the budget in one field and then make a calculation of (@budget - @all related expense) and get the remainder of the budget.
What I can't figure out is the code to allow me to say (@jan budget - @all related expenses JUST in the month of January).
Any ideas? Thanks!
Please sign in to leave a comment.