Counting Yes and No on a form

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
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 yes and no to get a percent.  Any ideas? 
Photo of Carl B

Carl B

  • 100 Points 100 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
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
Photo of Carl B

Carl B

  • 100 Points 100 badge 2x thumb
Thank you, that set me on the right path.  Works perfectly now.  Appreciate it.