Expressions

G

gwtechie72

I having problems using the expressions in the qurery. I am trying to get a
division of two fields using the expresstion formula but it is not working.
can anyone help me on this
 
F

fredg

I having problems using the expressions in the qurery. I am trying to get a
division of two fields using the expresstion formula but it is not working.
can anyone help me on this
Click to expand...

Crystal balls don't work on Fridays.
Can't help if you don't tell us what you want to do and what your
current expression is.
 
G

gwtechie72

ok.. I have 3 fields regardings this. uncontrolable, controllable, and
percentage. I have to take the total of controllable and uncontrollable and
divde it by the controlable to get the percentage. This is to show the
percentage of Work orders that could of been saved.
 
R

Rob Parker

If you want to calculate the result using the expression you posted, enter
the following in a new field in the query grid:
Percentage: ([Controllable]+[uncontrollable])/[Controllable]

On the other hand, if you wish to calculate the percentage which could have
been saved, enter the following:
Percentage: [Controllable]/([Controllable]+[uncontrollable])

HTH,

Rob
 
Top