how can i set up a simple budget remaining app that takes into account a set budget, multiple offices, and shows the budget remaining by office?

Question

I have an Application that i am tracking membership costs for the various organizations our employees belong to.  This list covers 5 offices.  I would like to be able to enter a budget amount for each office and have it track remaining budget each time I add a new membership for an office.

archiveuser · Answer

Create a table for "Offices" and have fields in that table for "Office Name" and "Budget Amount". Create a one-to-many relationship, so that One Office can have Many "Costs". Within that new relationship, create a Summary Field that takes a "Total" of the field where you enter the Membership Cost. Create a formula-numeric field in the "Offices" table and set the formula to:
[Budget Amount] - [Total Membership Cost]
using whatever you actually call the fields.
You will need to set the "Related Office" reference field value for all existing data so that it will include them in the calculations.
Hope that helps,
Keira

christianhilty · Answer

Keira,Are you still available for a question ?&nbsp;

quickbasecoachd · Answer

Keira rarely haunts this forum any more. Did you have a question. If you want to discuss a relationship setup one in one, you can contact me via the information on my website

QuickBaseCoach.com

Forum Discussion

how can i set up a simple budget remaining app that takes into account a set budget, multiple offices, and shows the budget remaining by office?

Related Content

Using Grid Edit to Edit Multiple Records at Once

Edit Multiple Records at Once with Grid Edit

Running total - PTO Days remaining

Billable step runs remaining

Calculate Hours/Day Remaining Needed in Year