calculating percentage based on value list in a summary report
I've been making no progress on this problem all week, so I'm hoping someone here can help me.
I am trying to use summary reports to do some very simple analysis on aspects of the data in my DB. What I need to do is calculate the percentage of a specific answer (from a value list) in a particular field out of all the records.
The Filemaker knowledge base has an entry for "Calculating Response Percentages of a Questionnaire" that would seem to be exactly what I need... but I've been unable to make it work. I am using Filemaker Pro v.9
Each record has a subject ID, and I need to calculate the percent of subjects where field G1_stop is "y". All of the data is in a single table.
Any advice would be immensely appreciated.