How do we display 2 different group summary fields as a percentage

[wynnengineer]

Hi,
Can I have a Group A (summary count) and a Group B (summary count) and create a field to calculate 1 - (Group B / Group A) to get a percentage ?

Running Totals perhaps ?

Looking for a direction to go.

Thanks.

wynnengineer

 

[lbass]

Yes, create two running totals, where you specify the group instance in the evaluation formula area, e.g.,

{table.group} = "A"

Then create a formula that uses the two running totals. You would have to place the formula in the report footer section, however (or in the footer of the second occurring group), so that the running totals have the correct value.

-LB