Jump to content

Variables and counting records


This topic is 4368 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I know this is easy for most-but I am struggling. I have a survey with Yes, No, Na check boxes. I want to have FMI count the number of "Yes", count "no" and count "na" while skipping the empty answers for multiple records. I am guessing there is a way to use a variable or global field or something. Right now--I am creating 3 different fields for one question. The actual answer as text (checkboxes). Then a calculation field for giving a numeric value to the answer (if (benefits = "yes";1;0), then summarizing the Total of Benefits.

I know there is an easier way.

Link to comment
Share on other sites

What I would like to end up with is a Summary page:

Question 1: 50% answered "yes"; 40% answered "no" and 10% answered "na" of the 50 people answering question 1.

Question 2: 30% answered "yes"; 30% answered "no" and 40% answered "na" of 45 people answering Q2.

Right now I have coded for question 1:

Q1 Text

Q1Scale = If (Q1= "yes"; 1, 0)

Q1RecordCount = Count(Q1Scale)

Q1Total Summary(Number) = Total of Q1Scale(running) **counting yes**

Q1TotalRecord Summary(Number) = Total of (Q1RecordCount) **counting questions that were answered regardless of answer**

Q1Average Calculation(Number) = Q1Total/Q1TotalRecord

This is only giving me the percentage for the yes answers. This just seems so cumbersome to repeat for Q2 then Q3 etc...

Link to comment
Share on other sites

This is only giving me the percentage for the yes answers. This just seems so cumbersome to repeat for Q2 then Q3 etc...

That's because there is a basic data structure problem with your approach. You will need to change your design.

The questions should be separate records, not separate fields.

Link to comment
Share on other sites

That's because there is a basic data structure problem with your approach. You will need to change your design.

The questions should be separate records, not separate fields.

So to clarify--if I have 40 questions there would be 40 records.

Could you recommend a good instructional manuel or training course.

Link to comment
Share on other sites

if I have 40 questions there would be 40 records.

Yes, but what's more important here is that if you have 40 questions and 20 people answering them, there should be 800 individual records in the Answers table.

See also:

http://fmforums.com/forum/topic/45972-another-survey-question/

http://fmforums.com/forum/topic/49072-surveys-and-relationships/page__p__229378#entry229378

Edited by comment
Link to comment
Share on other sites

This topic is 4368 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.