Grouping & Aggregations

Currently my project management system consists of several tables

  • Projects
  • Products
  • 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?


You would want to use a grouping and aggregation query! If you share more about your data model and exact info that you want to query and get back, I can help you author your query.