Audit Form needs to calculate % success

We are trying to calculate the success percentage of our cleaning staff based off an audit.

Our audit rating system is based off three selections.

1) Meets Standard

1) Below Standard, and

3) Not Applicable

We use non applicable for audit items that are not part of the scope of work. An example would be "Stair Wells Vacuumed" in a building with no stairs.

The equation we are looking for is;

[meets standard]/([meets standard]+[below standard])

Hi,

I see what you mean, I'll take a look closer on the equation that you have and will post the workaround that I have in mind. I'll get back to you as soon as I'm able to make my solution work in my end.

Thank you.

Hi again,

Here's the sample cloned form that I edited: http://form.jotformpro.com/form/43348003045950

What changes I did:

1. Added hidden input fields to store values specific to options: "Meet Standards", "Below Standards", "Not Applicable". I see in your conditions that each one has a value of "1"?

2. Add a condition to where if this checkbox is tick it will add a value on the hidden field.

Ex. If Entrance field has "Meet Standards" ticked, the hidden value "MeetStandardsM" will have a value of "1"

3. Added a Form Calculation for each total of "Meet Standards", "Below Standards" and "Not Applicable".

4. I don't quite understand the equation you have for the total % of audit, but you can check if my form does not correctly.

You can clone the form using this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

I hope this helps. Let us know if you need more assistance on this.

Thank you.

@corporatecleaning

It would be better to use radio buttons instead of checkboxes to restrict users to a single choice for each field, as I've done here.

Thank you Abajan, I will use radio buttons on my final form. Great idea.

Thank you Charlie, there is beauty in the simplicity of your approach, thank you again.

On behalf of my colleagues, you're welcome.

Let us know if we can be of further assistance.
Thank you.