# How can I get a form calculation to not include a not applicable field

• amesiano
Asked on December 16, 2015 at 03:04 AM

Hi,

I have put together a score card however some questions will not be applicable and thus I want to exclude them from the results.

e.g. 8 questions - which you can score 0, 1, 2, 3 rating or not applicable if it doesn't relate to you.

Thus for the section of 8 questions, if all questions are applicable then you get a score out of 24 (8x3), however if 2 questions are not applicable then you get a score out of 18 (6x3).

How can I get a form calculation to do a total so that I can determine what a score for that category is out of?

Cheers

Annie

• beril
Answered on December 16, 2015 at 08:29 AM

As far as I understand from your thread, when users selects N/A It multiples by zero or if the user selects Bad it also multiplied by zero so you can't determine the real score.

I suggest you to change ratings.

You can score 4, 3, 2, 1, and 0 for N/A. At that time, you can exclude the N/A option from calculation.

I hope it helps.

If you have any question or issues, please do not hesitate contacting us. We will be glad to assist you.

• Annie
Answered on December 16, 2015 at 03:15 PM

Thanks Beril.

unfortunately if I do this it still keeps N/a as part of the results.

if n/a is selected it needs to be removed from results as it means the category does not relate to them and they can not be scrored on it. If I leave it as zero means they are downgraded for not having that item.

Example;

8 questions means u get a score out of 24

but if 2 questions are n/a means your score is out of 18.

so I need to be able to determine what the score is out of based on the N/a select.

does that make sense?

• victor
Answered on December 16, 2015 at 04:09 PM

If I understand you correctly you wold like to count how many answers where N/A. From this multiple it by 3 and subtract it from the total (this case 24). In another words if a users select 4 N/As, the total would be:

4*3-24=12

I would think you would like this placed in the the field:

FOH GRAND TOTAL OUT OF

I will try to create a small work around for this. If I can find a solution I will let you know.

• amesiano
Answered on December 16, 2015 at 04:13 PM

Thank you so much Victor. This i exactly what I am trying to do.

I have been trialing Jot Forms and think they are great - if I can get this solved I will definitely by signing up for a subscription.

Many thanks

Annie

• Mike_G
Answered on December 16, 2015 at 07:24 PM

I was able to create a workaround for your concern. However, this only covers the first part of the computation which is FOH 1. To my understanding, you're trying to get the percentage of FOH score against the total number of questions that is applicable.

Here's a sample form, https://form.jotform.com/53497125381964

Here's how it works:

I was able to create it with the help of several additional fields (which are hidden so it will not appear on the form) and conditions to get the total number of non-applicable questions.

I will try to apply the same on the FOH 2 on the form and will get back to you.

For the mean time, please feel free to clone the form I have created using this guide: How-to-Clone-an-Existing-Form-from-a-URL

So that you can view how it was constructed. If you have any questions, please feel free to let us know and we will be glad to help you. Thank you.

• Mike_G
Answered on December 16, 2015 at 09:54 PM

I was able to create the same workaround for the FOH 2 on your form.

Just to explain what I did.

First, I have placed a value of 5 for the "N/A" row of the matrix. Just to make sure it has a different value from the other columns.

Second, I added calculation widgets on the form that will get the value of a row in the matrix field. So for every row, there is a corresponding Form Calculation widget.

Then, I added a Number field also equivalent to the total number of rows per matrix. The number field will have a value of 1 if the value of the Form Calculation I've added earlier is equal to 5. This is possible using conditions(Update Form field value). We need to do this to count the number of non-applicable questions.

Then, we add all the values of the number field into another field.

Now, since we can count the total number of non-applicable fields(N/A selection), we can subtract it from the FOH Total and FOH out fo fields.

Since the FOH Total gets the total value of all rows of the matrix, we need to deduct a value of 5 for every N/A selection.

The value that needs to be deducted is 5 because it is the value of the row if N/A is selected and we don't want that to be included in the total score.

Next, we remove the total number of non-applicable question multiplied by three(3) from the maximum total score that we can get.

The same workaround was applied to the FOH 2 on your form. Difference is that it has many rows from the FOH 1.

Here's a clone version of your form: https://form.jotform.com/53497125381964

Please feel free to clone it so you can inspect the conditions and additional fields I've added.

If you have any questions with any of the fields I have added or you need any clarifications with any of the instruction above, please feel free to ask and we will be glad to help you. Thank you.

• amesiano
Answered on December 17, 2015 at 04:10 AM

Thanks Mike. This is seems to work and be a big help.

I have about 10 categories to add. Is there any way or replicating this quickly?

Cheers

Annie

• Chriistian
Answered on December 17, 2015 at 04:52 AM

Hi,

Unfortunately, you will need to setup it this up manually on the other fields as the fields has a different setup. You need to setup the calculation manually for each field.

Do let us know if you need further assistance.
Regards.