question about using counts

[Brainiac58]

I am designing my first database and have a field called OjtOnTime that has the following calculation: Case (OjtComplete <=90;"Yes";OjtComplete > 90;"No";"NA"). I want to calculate the percentage of "Yes" responses. Would the following calculation do it? (Count"Yes"/Count"Yes"+Count"No")*100.

[Stuart Taylor]

Your math is wrong

I have 5 responses, 2 said no, 3 said yes

( 100 / 5 ) * 2 = 40% (percentage of no responses)

... your example

(Count"Yes"/Count"Yes"+Co unt"No")*100

or

(3/3+2) * 100 = 300%

[Lee Smith]

A percentage is equal to the YES divided by the Total .

i.e. in your example:

2 / 5 = .4 (40%)

However, I read the request a little differently.

Case ( (CountYes / TotalYes < .9) ; "YES" ; "NA")

If the N/A is meant as nil, then it isn't necessary.

If I have totally missed the point, I'm sorry for any confusion this may caused.

Lee