If you replace the calculation fields that aren't working with the three "coSum..." summary fields, do they show the correct counts in each sub summary part?
They show grand totals and not the subsummary totals.
And that would explain why getSummary is not returning the expected values.
What is the "sorted by field that you are using" for that sub summary layout part? If it were CoCounty, I would not expect to see grand totals when the summary fields are then placed inside the sub summary layout parts.
Once your summary fields correctly show the needed sub totals when placed inside a sub summary layout part, the getSummary function should then work to produce the desired percent.
I misunderstood. The "CoSum" fields do show the correct counts. But my calculations still aren't working. I'm sure it's something to do with my syntax.
Here is the full calculation that I would LIKE to use (I've been trying with just the middle portion and it's not working, but I'd eventually like to be in a full percentage form. This formula- without GetSummary works fine in the grand totals.):
Round (((GetSummary (CoSumMales ; CoCounty)) / (GetSummary ( CoSumGenders; CoCounty)) * 100); 1)
My found set is sorted FIRST by CoLead, THEN by CoCounty.
I tried even putting in CoLead in for county and still not getting a result. Then I tried just sorting by county, and it's still not working. Do I have my order for the GetSummary correct? First the field you want subtotaled, then the field that it will be sorted by, correct?
Thanks for your help with this.