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

2 Replies

Related Content

Same reference field, different selections within the form

An API(?) button to copy fields from the form, to other fields

Count Formula with Conditions

Graduate Count per Program per Year

Dynamic Form Rules

Recent Discussions

Create a formula duration over 5 years

Time of Day field values are not in 24-hour format in Pipelines

Join multi-line text field to one line

Report for Expired Training Records

Formula URL - Edit then Add