Discussions

Expand all | Collapse all

Counting Yes and No on a form

  • 1.  Counting Yes and No on a form

     
    Posted 01-16-2019 19:31
    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? 


  • 2.  RE: Counting Yes and No on a form

    Posted 01-16-2019 20:08
    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


  • 3.  RE: Counting Yes and No on a form

     
    Posted 01-17-2019 13:20
    Thank you, that set me on the right path.  Works perfectly now.  Appreciate it.