Audit Form needs to calculate % success

  • Profile Image
    Asked on December 01, 2014 at 06:28 PM

    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])


  • Profile Image
    Answered on December 01, 2014 at 08:38 PM


    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.

  • Profile Image
    Answered on December 01, 2014 at 08:58 PM

    Hi again,

    Here's the sample cloned form that I edited:

    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: 

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

    Thank you.

  • Profile Image
    Answered on December 01, 2014 at 09:22 PM


    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.

  • Profile Image
    Answered on December 02, 2014 at 01:59 PM

    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.

  • Profile Image
    Answered on December 02, 2014 at 03:05 PM

    On behalf of my colleagues, you're welcome.

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