Skip to main content
Question

Counting Yes and No on a form

  • January 17, 2019
  • 0 replies
  • 35 views
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? 
    This topic has been closed for replies.

    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
    • Author
    • Registered
    • January 17, 2019
    Thank you, that set me on the right path.  Works perfectly now.  Appreciate it. 
    Terms & ConditionsAccessibility statement