5 Replies Latest reply on Jul 22, 2010 12:39 PM by philmodjunk

    calculating percentage based on value list in a summary report

    AutumnAgnoli

      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.