Percentage of total choices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that has many different questions. Fo each question there
are only two options. I want a report that displays the percentage of option
A selected. I only want that in terms of total answered. If for that question
no answer is given, then it should not be included in the calculations.
 
Could you share a few records with data types and field & table names? Then
show us how you would expect these records to appear in your report.
 
Here is an example of a record:

1_Dedicated_volumetric
1
0
2

The Table name is Data_sheet
The Field name is 1_Dedicated_volumetric
The field type is number
The field is filled in from a form with two option boxes. Option 1 is given
a 1. Option 2 is given a 2. If an option is not selected, the value is 0.
I would like the Report to give the % of option 2 for each question. However
I would like it only to be counting questions that were answered. I would
also like the report to have the total number of option 2's with a sum of
each individual percentage.
This database collects data on observations. Not every question will be
observed on each record. This is why I want the report to only examine
answered questions.
I hope this better explains what I am looking for.
Tyra Horner
 
In a report group footer section, you can get the percent of 2s by using:
=Sum(Abs([1_Dedicated_volumetric]=2))/Sum(Abs([1_Dedicated_volumetric]<>0))
 
Back
Top