Formula Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query with the following Headers

Language, Passed, Failed

I need to get a Percentage of How many English Reps Passed or Failed the
Exam. In the Query the results displayed are:

Language Passed Failed
English 1
Spanish 1
Russian 0

Would you recommend a formula in the Query or Report and what would be the
formula. I have tried different formulas in the Control Source but Do not
get the result needed. Please help. Thanks.
 
The actual formula is quite simple but is a little more
complicated if you want to allow for 0 or null values. I
would have a 'hidden' field on the report (eg 'MyPass')
with a formula:-
=nz([passed],0)+nz([failed],0)

in the field to be displayed:-
=if([failed]=[MyPass],0,([mypass]/[passed])*100)

This could all be added togeather to ignore the extra
field, but hey I'm all for an easy life
 
ACG,

The formula works like a charm! Thanks for your Assistance!



ACG said:
The actual formula is quite simple but is a little more
complicated if you want to allow for 0 or null values. I
would have a 'hidden' field on the report (eg 'MyPass')
with a formula:-
=nz([passed],0)+nz([failed],0)

in the field to be displayed:-
=if([failed]=[MyPass],0,([mypass]/[passed])*100)

This could all be added togeather to ignore the extra
field, but hey I'm all for an easy life
-----Original Message-----
I have a query with the following Headers

Language, Passed, Failed

I need to get a Percentage of How many English Reps Passed or Failed the
Exam. In the Query the results displayed are:

Language Passed Failed
English 1
Spanish 1
Russian 0

Would you recommend a formula in the Query or Report and what would be the
formula. I have tried different formulas in the Control Source but Do not
get the result needed. Please help. Thanks.


.
Click to expand...
Click to expand...
 
Back
Top