I am trying to calculate the percent of completion of jobs using the total hours in assembly 0. I would like to do Assembly Total Actual / Assembly Total Estimated Hours to get the percent complete.
How do I get/calculate these fields in a BAQ? It doesn’t appear that the SubAsmblyCostHours table is available. I am assuming I could just do the sum(labor hours) per job to get the actual hours. Where do I find the total estimated hours?
They can be found on the JobAsmbl table: TLESetupHours, TLEProdHours, LLESetupHours, LLEProdHours. TL is this assembly level, LL is the lower level assemblies. The actuals are on there too (TLA / LLA).