Google Sheets Group BY Aggregation functions SUM(K * M) error

Question

In Google sheets I have 1 sheet with data (Table headings), then I have another sheet where I wish to query certain information.

This is the basic QUERY I am using:

select O, SUM(K*M) group by O

This is the error I receive:

Unable to parse query string for Function QUERY parameter 2: PARSE_ERROR: Encountered "*" at line 1, column 16. Was expecting: ")"

Would this be a issue with the data range that I am using?

Answer 1

Google Sheets Query() is not able to SUM calculated columns like MYSQL. A workaround would need to be used.