Jump to content

question about using counts


This topic is 5756 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 5756 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.