I have a Crystal Reports 8.5 report with 3 total reports (2 are subreports). The main report is the Direct Labor Dollars report. The two supreports are Indirect Labor Dollars in report footer a and Apportioned(Overhead) Labor Dollars in report footer b. Each report returns a specific type of labor dollars for Specific cost centers. I need to add the specific Cost Center Direct and Indirect Labor Totals and then add the Direct and Indirect Labor Totals and then divide each Cost Center Total into the new aggregated (Direct and Indirect Labor) total to get the ratio used by each cost center. Those cost center ratios will then be used to divide up the apportioned labor. How do I add the separate report's specific Cost Center Dollars and Total Dollars? I've attached the report I have so far.
You have direct labor in the main report and indirect labor in the first subreport.
You want (CostCenterA(Direct) + CostCenterA(Indirect)) / (TotalDirect + TotalIndirect)
You then need to use that to determine how much of the costs in the second subreport to apportion to each cost center?