I'm using jotform to create a scorecard for graded phone calls. Can't figure out how to eliminate questions that are N/A'd from the total?

I have 15 questions on my scorecard.  The options for each question are yes (which awards a certain number of points), no (which awards zero points), or N/A (which also awards zero points).  At the end of the scorecard it totals the number of points awarded and divides it by the number of possible points.  However, in the case of the N/A'd questions I want to be able to have the total possible number of points automatically adjust and eliminate the possible points from that question so it doesn't throw off the total.  Is this possible?

Hi,

I checked your jotform http://www.jotform.us/form/41116703508144  and the method you did in calculating the Total.

BUT I think it will be much simpler and more workable if you instead do it by following the method on this user guide

http://www.jotform.com/help/259-How-to-perform-calculation-in-the-form

In the Dropdown List properties, you can assign a Calculation Values for each of the options

You can then Calculate the Total and even a separate sub-total for the N/A answers.

If you assign a value of -1 to N/A answer then you can immediately deduct this from Total or calculate all N/A into a separate Total of its own.

Hope this help. Tell us if you need further assistance on this.

I will also try create a demo form that shows what I meant. I'll get back to you quickly on it.

Thanks.

I will take a look at the form, a demo would be helpful as well.  Thanks for getting back to me.