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).
Thanks, Adam! I think I am very close with your help!
I am adding the TLESetup, TLEProd, LLESetup, and LLEProd hours all up to get the total Estimated hours.
How do I pull in ‘this level’ hours as well to get the total?
That SHOULD reflect the tracker. I see that you have TLESetupHours added two times, no TLEProdHours. Could that be the issue?
Wow. What a silly mistake. Thanks for your quick and easy help finding that!
No problem! Glad I could help.
