I have a similar question but not exactly what I have seen so far.   I have a report that I show each line as "pass" or "fail".  There will be many groups in this report so I will have a group and total summary.  

 

I am using counters and summarize them for the group footer (this works fine).   Now I also need to provide for each group the percent that passed and failed.   When I create a formula to calcuate the percent, it is using all of the records for the calculation not just for this group.   This is because the formulate workshop does not appear to know about a group break.

 

Ideas as to how to create percentages for a group based on the summarized group totals and for each group?   Thanks all.

     Thanks for responding.  Yes, while suming in the formula I forgot to add the group option which caused it to sum for the entire report.   I seems to work now, thanks for the tip!

Scott