Jump to content
Server Maintenance This Week. ×

caluculations-summaries and stupid newbie question


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

Recommended Posts

  • Newbies

Sorry, but I'm a stupid newbie. I am totally lost, but here's what I'm trying to do:

I have a "yes" and "no" check box. When yes is checked, I'm trying to get a field to keep track of the number of times it is checked whether it be yes or no.

For example, the database keeps track of number of jobs won and lost. So the final result should be something like this: 9 out of 10 jobs were won resulting in a job-received rate of 90 percent.

I am so lost I don't even know where to start...

Link to comment
Share on other sites

Is this one field with the choice of Yes or No? If so make 2 calculated number fileds. Won = Case ( Ans = "Yes", 1, 0) and Lost = Case ( Ans = "No", 1, 0). Make summary fields that total Won and Lost.

Link to comment
Share on other sites

This topic is 7263 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
×
×
  • Create New...

Important Information

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