Further Summary details (1 Viewer)

[Mark Liddle]

Hi All
I have a database that records the Maintenance & Repair costs for vehicles, per Department.
I have got the report to give me the usual summary details as follows.

Department 1
Vehicle Name1
Repair Item 1 Cost1 Labour1
Repair Item 2 Cost2 Labour2

Total Cost 1+2 Lab1+2
Ave Ave(Cost1+2) Ave(Lab1+2)

Vehicle Name2
Repair Item 3 Cost3 Labour3
Repair Item 4 Cost4 Labour4
Repair Item 5 Cost5 Labour5

Total Cost 3+4+5 Lab3+4+5
Ave Ave(Cost3+4+5) Ave(Lab3+4+5)

Summary
Total Cost(1 to 5) Lab(1 to 5)
Ave Cost(1 to 5) Lab(1 to 5)

My problem is that the above summary only give the SUM and AVG for each department.
I want to calculate additional Total and Average costs for the company as a whole,
in the same report

I.E.
1. Dept/Vehicle Average = sum of all costs accrued to that Dept / number of vehicles in the Dept.

2. Department Ave = sum of ALL costs / number of depts

This obviously requires that somehow I count the number of vehicles and departments and build it into the calculation on the report. But how ??

Thanks for your assistance.

 

[peters]

Hi Mark.

Trying playing with where you put the calculaiton. Which groups header or footer you put the calculation into will determine which values are bieng used.

Trying putting your Total and Average calculation in the report footer.

Hope this points you in the right direction.

 

[Mark Liddle]

Thanks - will give it a go.