How to do complex calculations inside query formulas?

Question

In Google sheets, I get #NA with no explanation when I try to calculate the change between two sums - that I have just calculated in that same formula.

Is that not possible using query or am I doing it wrong?

• My formula: =query(B5:H16,"select ((sum(G)/sum(F)) - (sum(D)/sum(C))) / (sum(D)/sum(C))")

The first part is working: =query(B5:H16,"select ((sum(G)/sum(F)) - (sum(D)/sum(C)))

I'm trying to do the same calculation as the formula in A3 in the screenshot - but within the query formula

Spreadsheet link: https://docs.google.com/spreadsheets/d/1VrYO-TayV6TD-iHUDT3Axgkr3gI4s9OHvj0-yW59wRA/edit#gid=0

Answer 1

Wouldn't this be equivalent to the formula you are trying to get?:

=query(B5:H16, "select (sum(G)/sum(F))/(sum(D)/sum(C)) - 1")

I hope this is of any help.