PerfectForms Forums » Reporting

1. frank1
   Member

   Hello,

   Our questionnaire consists of 50 different questions. In order to get a summary of how well each person answered, we would like to have a "weigth" for each question.

   For example:

   Question 1: Do you have quality processes?
   Yes = 1 point
   No = 0 point

   Question 2: Which quality standard do you have ?
   ISO 9000-1 = 1 point if checkbox is checked, 0 if unchecked,
   ISO 9000-2 = 1 point if checkbox is checked, 0 if unchecked,
   ISO 14000-2 = 1 point if checkbox is checked, 0 if unchecked,

   Question 3: Do you ship to the U.S?
   Yes = 1 point
   No = 0 point

   and so on...
   At the end the questionnaire, we would like to compile and report a total score. In the above example, if the person answered

   Question 1: Yes = 1 point
   Question 2: Checked ISO 9000-1 = 1 point
   Unchecked ISO 9000-2 = 0 point
   Unchecked ISO 14000 = 0 point

   Question 3: No = 0 point

   Total Score = 2 / 5 = 40%

   Is that something that can be done? If not, I know it can be done in Excel.

   Thanks,

   Posted 2 years ago #

2. ajobling
   Member

   If you use Radio Buttons for your responses (This allows just one answer) then the Radio Button Group (i.e. the question) can have a value attached to each answer.
   The values can be added up at the end.
   Be aware, however, that if a Radio Button Group is not answered at all then it will have the value of 0.
   If you are using checkboxes for your responses (This allows multiple answers) then you need to add in some logic which is based on the responses. Each checkbox will need a corresponding input object. Then the behavior would be:
   If ISO 9000 is checked then value = 1
   If ISO 9000 is not checked then value = 0

   Posted 2 years ago #

RSS feed for this topic

Reply

You must log in or register to post.