I am trying to create a query calculation that
(field1 * field2)-10% of the value of field1 * field2
I am trying to create a query calculation that
(field1 * field2)-10% of the value of field1 * field2
Try:
(field1 * field2)*(9 / 10)
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick
That did work - could you explain that formula?
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?
If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
Bob Fitzpatrick