4 Replies Latest reply on Oct 14, 2014 1:46 PM by NonProfitEducationUser

    Getting a percent in a report subsummary field

    NonProfitEducationUser

      Title

      Getting a percent in a report subsummary field

      Post

      Hi,

      I am having trouble with creating a percent of a total in subsummary fields. I am trying to calculate the percent of male and female attendees based on a total of the attendees in their county.  All fields are in the same table occurrence.

      I tried following the example found here but I'm not really sure how to change it to fit my situation:

      http://forums.filemaker.com/posts/5391ad20e3

      But I am getting blanks as was mentioned. I have the field in a subsummary section of a report. (I have no issues with the grand summary- I use a calculation field there).

      I am using this calculation:

      (GetSummary ( CoSumMales ; CoCounty)) / (GetSummary ( CoSumGenders; CoCounty))

      Where CoSumMales is a summary field of males. And CoCounty refers to the cohorts county. CoSumGenders is a summary of all the males + females.

      The report is sorted by educator, and then by county. (Even when I just sort by county, the calculation still isn't working).

      I am looking for a report that would look like this:

      Teacher A Name

            County A              total number of participants                  %male   %female

             County B              total number of participants                  %male   %female

      Teacher B Name

            County C              total number of participants                  %male   %female

             County D              total number of participants                  %male   %female

      GRAND TOTAL     total participants   %male %female.

       

      The totals and the grant totals work fine; I just can't get a % for each gender based on the county.

      I know how to make a number (like .6) in to a percent for the report, I just don't know how to get FM to return that first number for me.

       

      Thanks for your help.