Counting Yes and No on a form
I have a form which contains 25 questions. For each question is a drop down which contains yes or no as a possible answer. I want to count the number of yes, then divide that number by the total of...
Forum Discussion
Here is an example with 5 questions.
(Case([Was Status Correct?], "Yes", 1, "No", 0) +
Case([Was Hold Reason Correct? (If applicable)], "Yes",1 , "No", 0) +
Case([Purchase Date Within Program], "Yes", 1, "No", 0) +
Case([Attachment], "Yes",1, "No", 0) +
Case([Invoice Number],"Yes",1, "No", 0))
/
5
(Case([Was Status Correct?], "Yes", 1, "No", 0) +
Case([Was Hold Reason Correct? (If applicable)], "Yes",1 , "No", 0) +
Case([Purchase Date Within Program], "Yes", 1, "No", 0) +
Case([Attachment], "Yes",1, "No", 0) +
Case([Invoice Number],"Yes",1, "No", 0))
/
5