G
Gillian
I am attempting to develop a form with calculations but am having significant
difficulty. The form will be filled in by a monitor who is listening to staff
performance in a call center. There are 3 sections in the form (Staff
Professionalism, Documentation etc). Each section of the form should add up
to 100 and I would like a percentage for each section and an overall
percentage for all 3 sections. The problem is that each question on the form
is weighted differently and some questions may not apply to that specific
call. In designing the form, I would like the monitor to be able to just
check off a box next to each question and for the scores to be automatically
generated. I tried using toggle/check boxes but cannot assign a specific
value beyond one or zero. I then tried to have a drop down option (such as a
score of 5,0,N/A) for each question but in order to include the N/A feature
the box must be a text box and then no calculations can be done. I also need
the final calculations to be based on only those questions that are relevant.
That is, if a question does not apply to a particular call that it not be
stored as a zero value as it will throw off the overall percentage. I need it
not to be included at all in the overall score. I hope this makes sense.
Please help!
difficulty. The form will be filled in by a monitor who is listening to staff
performance in a call center. There are 3 sections in the form (Staff
Professionalism, Documentation etc). Each section of the form should add up
to 100 and I would like a percentage for each section and an overall
percentage for all 3 sections. The problem is that each question on the form
is weighted differently and some questions may not apply to that specific
call. In designing the form, I would like the monitor to be able to just
check off a box next to each question and for the scores to be automatically
generated. I tried using toggle/check boxes but cannot assign a specific
value beyond one or zero. I then tried to have a drop down option (such as a
score of 5,0,N/A) for each question but in order to include the N/A feature
the box must be a text box and then no calculations can be done. I also need
the final calculations to be based on only those questions that are relevant.
That is, if a question does not apply to a particular call that it not be
stored as a zero value as it will throw off the overall percentage. I need it
not to be included at all in the overall score. I hope this makes sense.
Please help!