Query Calculation

[Rhubie]

I am trying to create a query calculation that

(field1 * field2)-10% of the value of field1 * field2

[Bob Fitz]

Try:
(field1 * field2)*(9 / 10)

[Rhubie]

That did work - could you explain that formula?

[Bob Fitz]

If you deduct 10% you are left with 90%. Which is 90/100 or 9/10.
field1 * field2 is 100%. Calcutations are done inside the brackets first. So (field1 * field2) * (90 / 100) will calculate field1 * field2 then it will calculate 9/10 then it will mutiply the result of each calculation. Does that make it any clearer?