Hello,
Maybe someone can help me. I build the query and its finished I made sure the info was correct by defining it by 1 job and checking against that job. now that I remove the define job and ready to run it wide open it errors out.
if anyone knows how let me know Im stuck.
JobCostingDashboard.baq (61.6 KB)
I did not validate the data, but I made it run and give me one line per job by grouping by everything in subquery1 except the calculations and putting MAX around all of the calculations fields from the subqueries. It would be easier to understand if instead of subquery1-4 you gave them meaningful names like top, labor, material, etc.
calcs
