Currently my project management system consists of several tables
- Project Items
Each project item has a projectid, hrs, labor total, qty, material cost,
Each project has a sum of material cost, labor total, and hrs for each project item that has the ID of the corresponding project. As well as having a project total that is a calculated field that sums up the previous fields.
I read the documentation and it looks like I can’t query columns in another table using a calculated field. Would the better way to get these totals in projects be to use grouping and aggregations? or is there an actual way to sum them using a calculated field?