Problem With Summary in report

[Lee J]

I have two reports which can include data on a single job or multiple jobs.

Currently the Find ans Report request are perfomed in the time and material DB.

The final calculation requires the system to divide the final total by a number value defined in the Estimate database. "TotalSKU" to give a "ProfitBySKU" value

It works fine on a single job report but when I try to use this against multiple jobs it is incorrect.

How can I get the total os "TotalSKU" from the estimate DB and transfer it to the T&M database so I can use it in the "ProfitBySKU" field?