Counting Yes and No on a form

Question

I have a form which contains 25 questions.&nbsp; For each question is a drop down which contains yes or no as a possible answer.&nbsp;&nbsp; I want to count the number of yes, then divide that number by the total of yes and no to get a percent.&nbsp; Any ideas?&nbsp;

quickbasecoachd · Answer

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

carlbaldwin · Answer

Thank you, that set me on the right path.&nbsp; Works perfectly now.&nbsp; Appreciate it.&nbsp;

Forum Discussion

Counting Yes and No on a form

Related Content

Switch between forms

Prevent save a record - New forms

Form Rule Question

Add child record through parent form and redirect back to parent form in edit mode

Totaling Child Records Live on Parent Form