Hi! I have what I think is an easy question, but I can't get it to work.
I am in the real estate business. I buy houses fix them & resell them.
I have 1 workspace with 3 different apps.
App 1 is just general information about the property such as property address, # of bedrooms, etc. This app works fine.
App 2 - Labor (This is where I list all the costs that each contractor charges such as plumbing, electrical, etc.) Below is a screenshot of part of App 2. App 2 also has a Relationship field to App 1.
App 2 above also has a Calculation field at the bottom of each contractor category, which totals up the costs for that contractor. So for example, I have a Calculation field after plumbing named Total Amount For Plumbing, one after electrical called Total Amount For Electrical & so on. That Calculation tells me how much I owe each individual contractor.
Also in App 2 I have another Calculation field that totals up all of the different Calculation fields combined & gives me a grand total for all of the different contractors. Below is what that grand total Calculation looks like.
As best as I can tell all of the Calculations in App 2 above work as they should.
App 3 - Payments This is where I want to list payments made to EACH different contractor as I make those payments & keep a balance of how much I still owe for each contractor. Then I want to have a 2nd Calculation that is separate to keep track of the TOTAL balance still owed for ALL contractors combined. In other words, I want to calculate how much I still owe to each separate individual contractor as each payment is made to them & then I want to have a separate calculation that shows the total of how much I still owe for ALL of the contractors combined.
Below is a snapshot of part of App 3. I have a Relationship field in here to App 1 & App 2.
App 3 is where the problem is. Below is the Calculation I tried to use for Plumbing. When I try to pull over the Total Amount For Plumbing field from App 2, it will not calculate that field, even though I selected it from the drop down list.
The reports show that the rest of the calculation did just fine, but it will not include the @Sum of Total Amount For Plumbing field in the calculation.
How would you set up the calculation for EACH individual contractor to show the total balance that I owe minus the amount that I have paid each one of them so far?
How would you set up the 2nd calculation so that it gives me the TOTAL that I owe to ALL contractors combined minus the amount that I have paid them so far?
Does anybody know what formulas I need to use to accomplish these Calculations?
Thank you so much for your time. This is a very nice forum by the way.
Please sign in to leave a comment.