Brainiac58 Posted January 2, 2007 Share Posted January 2, 2007 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. Link to comment Share on other sites More sharing options...
Stuart Taylor Posted January 2, 2007 Share Posted January 2, 2007 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% Link to comment Share on other sites More sharing options...
Lee Smith Posted January 2, 2007 Share Posted January 2, 2007 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6342 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now