I have two groups in my report. Group 1 defines the group names (group a, group b, etc.) Group 2 defines stratums within the group (Group a stratum 1). I have manual running totals in each group. I need to create a formula that references the running totals in both groups and calculates a percentage that displays in the footer of Group A. Example: (RunningTotal Group A -RunningTotal Group B)/RunningTotal Group A. When I try this calcuation either 0 or the last value in the running total is displayed. How do I get around this?
