Radio Button Calculations with N/A

[sharab39533680]

I am creating a fillable form, where the user has the option of 5 radio buttons. Option 1 is N/A. Option 2, 3, 4 and 5 all have values associated with them. Ultimately I'd like to add up the scores for all fields in the form, to get a total, and ultimately a percentage, at the end.

There are 58 questions, fit into 8 sections. I'd like to total up each section, so in each section we have a score, and then total it at the end.

The issue is that I can not figure out how to remove the scoring for the N/A option, so it doesn't negatively affect the score for the individual.

My Radio  Buttons are called "Group 1", "Group 2", etc, through to group 58

Here is my scoring sheet as well

Can anyone point me in the right direction?

Thanks so much for your time!

[try67]

Are you calculating an average, or a total? If the latter then having "N/A" as one of the selected values should not be an issue. If the former then it can be solved using a script.

[sharab39533680]

I do want an average yes. I am unsure of how to write a script. Would you be able to point me in the right direction to do something like that?

[try67]

I published a script that does just that on these forums. Search for "calcAverage". If you can't find it I'll repost it.

[sharab39533680]

I found it thank you. I'm going to try to figure out how to make that work in my document. This is my first time really using scripts, so I need to try to wrap my mind around it, but thank you so much for giving me a head-start.

[try67]

There should be some examples. Anyway, if you're having problems post back and I'll help you out.

[sharab39533680]

Another question - sorry, for the basic question: Do I need to have a script writing program for this? I'm coping and pasting into word and its getting all messed up. One of the reviews online said I need a script writer such as Vim.

[try67]

No, but you do need to use a plain-text editor.

What's your OS?

[sharab39533680]

I'm on windows 8.

[try67]

Then I recommend using Notepad++.

You can set the Language to JavaScript to get styling of the code, which helps a lot.