We have created an assessment and now we need to add a data score to it. So the assessment has 5 questions where the answers from the drop down can be: "Yes", "No" or "N/A".
Values associated to the answer options:
Yes = 2
No = 1
N/A = Should not count.
Assessment ie1.
Q1=Yes
Q2=No
Q3=N/A
Q4=Yes
Q5=N/A
So the math must be (2+1+2)/3=2.5
Assessment ie2.
Q1=N/A
Q2=Yes
Q3=Yes
Q4=No
Q5=Yes
So the math must be (2+2+1+2)/4=1.75
Whenever there is a "N/A" as answer, it must Not count on the answer SUM as well as well Not in the questions answered to be divided.
Thank you,
