This seems like a very complicated design. What if your business model changes? You will have to go back and change all the percentages, or if you have more then 5 fields. If you could explain a little more what you are trying to accomplish, it would help.
Also, why 5 additional fields? Seems like (to me) you have five cost fields, and a miscellaneous cost field. Then you want another cost field that acts as some kind of way to add a premium to the original cost field.
Where do the initial values come from for Costs A-E?
As an example, lets say you have 5 costs fields
Costs A: $500.00
Costs B: $400.00
Costs C: $300.00
Costs D & E are empty
Total Other Costs: $600.00. In your post, The total calculated costs should be: $1200.00 (A,B,C) + $200.00 (33.33% of Total Other Costs) which = $1400.00. Do you need to have A, B, C, now adjusted, or Total Other Costs adjusted?
Where/how do you want that shown? On an invoice, etc.? Do you have a sample file or layout that could provide more detail?
I think if you can describe exactly what you going for, others can help a little better.
Thanks so much for the quick reply. I am trying to format estimating for paint finishes. When the estimate is printed, I want to show the breakdown of each item as well as the total.
I hope this screen shot helps
Attaching this time, sorry
I am trying to format estimating for paint finishes. When the estimate is printed, I want to show the breakdown of each item as well as the total.
Have you looked at the Estimates starter solution that comes with FileMaker 13? Even if you can't use it "out of the box", it may be a useful source of ideas. In particular, the way that it uses a portal to a related table to list each item (your break down) that contributes to the total cost of the estimate.
So many thanks Steve. Although it didn't quite match but so nearly there and pointed me in the right direction. After some fine tuning yesterday, it now functions exactly as I needed it to. Thank you again for being so generous with your time and expertise.