Help! I’m pretty good with BAQs, but this one has me stumped. I have a report pulling basic data for manufactured parts. Here’s the portion of the report that is working.
BUT I want to add a column to the report that shows the total production quantity for open jobs, so users know what’s coming. When I add the JobHead table to the report, it multiplies the calculated fields (all just sum calculations). I know this has something to do with the join, but no matter how I change the join, it doesn’t pull the correct values.
Standard subquery should be fine, group by company, partnum, and do your calc fields there. JobHead table should be all you need (probably filter it down to open open jobs\released jobs).
