Issue fixed in Sage 300 Construction and Real Estate version 22.2. The lastest version of Sage 300 Construction and Real Estate can be downloaded at Sage 300 Construction and Real Estate: Download Portal For versions prior to 22.2, you can do one of the following: Option 1: You can download this report and replace this with the original report on your Payroll Report Menu. See How do I save, add, and print a report design? for steps to run the report. Attachment: PRMonthlyEmploymentUtilizationEEOmod.rpt Option 2: You can modify both formulas and replace the Subtotal and Total formula with your modified formulas. - If you choose this option, you are modifying the totals in the Asian/Pacific Islander columns.
- Make sure that the print controls are set appropriately for these new fields on the report.
- Rename the existing report to something like Monthly Employment Utilization Report-MOD.
Replace the "Total Asian Hours" formula with the following formula: Total Asian + PI Hours: ASUM(, IF((LOOKUP(Ethnic[PR Employee], Employee[PR Time])="Asian" OR LOOKUP (Ethnic[PR Employee], Employee[PR Time])="Pacific Islander") AND Report_Cond[Design Formula]=Yes, Units[PR Time])) Replace the "Trade, Asian Hours" formula with the following formula: ASUM(Certified Class[PR Time], IF((LOOKUP(Ethnic[PR Employee], Employee[PR Time])="Asian" OR LOOKUP(Ethnic[PR Employee], Employee[PR Time])="Pacific Islander") AND Report_Cond[Design Formula]=Yes, Units[PR Time])) |