1 of 1 people found this helpful
You would create a subsummary part above the body part that subsums based on location (IE london, paris), just dropping in a merge field to display city name, and a calc(line total) calculation for the location total.
Then you would create a trailing grand summary part that held the sum calculations.
calc_lineTotal - calculation field type = machine cost + travel cost
sum_machineSubTotal - Summary field type = running total of machine cost
sum_travelSubTotal - Summary field type = running total of travel cost
sum_total - summary field type = running total of calc_lineTotal
You would put the sum_total in the subsummary part, then all three sum_ fields in the trailing summary part.
Check out this article for an intro to subsummary parts:
And this one about trailing summaries:
I took a quick look, you didn't mention you're putting fields (and sums) from two separate tables on the single report. That makes things marginally trickier.
All the summary fields for the display should be from the same table the layout is configured for in order for the math to show up correctly. In your case, the "maquinas" table.
Since there is a "cost" for each "machine", you need to calculate the "share cost" of that machine. IE if you have 4 machines in your report, and each of them has a cost of 200, you only want to return 200 (as opposed to a summary returning 800), so you calculate that each machine has a "share cost" of 50, and then summarize that.
I have adjusted, Check it out.
First of all many thanks.
Two more things.
The real value i have for the machine cost is some value for all machines. i think this could help in the report, but i could not realize how to do it.
One more thing, i did not know that the summary fiels should be all from the some table. I realy have 3 tables that should be in report. Costumers, Machines and Service Orders. My questions is: should it work if i create a new table with lookup to each field i need to put in report. Really the summary fields are only from 2 tables but...
For end, in cetain cases i have 20 or more machines in some city, sharing the cost i think it could be dangerous about the rounding values. I must review the two or more, table problem.
Once again, thanks for the "light"
As should have realized I am a beginner in Filemaker Pro.
Let me ask you one more thing. I've calculations and values (things like distances, fuel cost, expenses and so on...) in other tables, in "good modeling database" rules, do you think is good thinking to put all those values and calculations in only one table and make relationships between all tables.
Once again, thanks for your time.