Finding percentages of value lists

[Nic Brown]

I have a Survey database that I created and there is simply 1 field per question that has about 4-5 answers. For example:

Q1. How do you rate our customer service?

And then a "radio button" value list of A, B, C, D, F, Don't Know

What I would like is for FileMaker to take all of the "Completed" survey's and determine percentages for each answer. Using a calculation/script it performs a find of "Completed" and tally's the A's for question one, divided by Found Count and returns a percentage so that I can see basically:

Q1:

A - 9%

B - 13%

C - 22%

etc..

Q2:

A - 15%

etc..

Any ideas are greatly appreciated!!

Thanks,

Nic

[Ender]

Welcome Nic,

You can do this reporting in layout based on a table where each record is one Question. Then use separate fields to hold the counts of each response. The percents can be derived easily from those counts.

However, the implementation of this depends on how your survey is structured. If you currently have one record per survey, with each question as a separate field, you'd need to use a script to loop through the questions and set the counts for each question in the Question table. If instead you have a Survey table, a Question table, and an Answer table (a join of Survey and Question,) the counts would either be simple Count() calcs within the Question table, or summary fields within the Answer table.

I suspect your structure is one record per survey, with multiple question fields. If this is the case, you might search the forums for "survey" or something similar. I recall discussing this structure last summer or fall.

Let us know if you still need help.