AnsweredAssumed Answered

calculating percentage based on value list in a summary report

Question asked by AutumnAgnoli on Jul 22, 2010
Latest reply on Jul 22, 2010 by philmodjunk

Title

calculating percentage based on value list in a summary report

Post

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.

Outcomes