1 Reply Latest reply on Apr 18, 2011 10:24 AM by philmodjunk

    Totaling Yes Boxes

    gldiaz

      Title

      Totaling Yes Boxes

      Post

      I need assistance with a way to get totals on a  survey using YES and/or NO boxes.

      I would like to get a total of Y and/or No boxes for a type of survey.

      ex.      Do you like milk?      [x]  Yes   [  ] No
                 Do you have a car?  [x]  Yes   [  ] No
                 Do you want taxes?  [ ]  Yes   [x} No

      Total    Yes ________                        No_________

      And the survey could have more boxes. So how would one set up the DB to be able to take a

      count of the YESs and the NOs.  Also how to the YESs and NOs get defined? Can you help?

      Finally, if the total number of boxes fall particular ranges . the totals are shown in a selected color.

      ex.  Range 1-10  YESs = green colored TOTALS.

             Range 11-50 YES = Yellow colored Totals

             Range 51-100 YES= Red colored Totals.

      Therefore. after the boxes are totals and fall within a selected range, the results should show in a particular color and colored.

      Is this possible?

      Tks

      GD

        • 1. Re: Totaling Yes Boxes
          philmodjunk

          First, research "Survey" here in this forum. Getting the correct table structure and relationships can save you hours of time here when it comes time to analyze your responses.

          Second, one favorite suggestion of LaRetta's makes a lot of sense here:

          Define the response field as a number field and set up a value list for your yes no field to enter 1 or 0 rather than yes or now. That makes counting the yes responses as easy as simply using a summary field to total up the value of this field across all the response records for this individual. You can edit your layout to resize the yes/no field to hide the numbers and add layout text for the yes and no labels.

          Conditional format expressions can be used to provide your color coding when the summary field computes a sub total in the desired ranges. (Use Get Summary may be needed if you bring up responses for more than one respondant at a time.)