November 19, 200124 yr 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?
Create an account or sign in to comment