Group by in report footer

[PPetronas]

I have a report which looks like:

Price Amount
Charges $0.00 $0.00
$4.99 $14.97

Total $14.97

Refunds Price Amount
$10.99 $10.99

Total $10.99

Now I want to have Net Charged in the Report footer as (Charges Total -Refunds Total).
I have a sum(amount) in the group footer which calculates the Total for each section.
Any help will be appreciated.

Thanks,
Petronas

 

[swiss2007]

Create this formula and place it in the report footer.

WhilePrintingRecords;
currencyvar Refunds/Charges :=Sum({Amount}, {groupname});

currencyvar maxsum;
currencyvar minsum;
currencyvar diffsum;

if Refunds/Charges > maxsum then
maxsum := Refunds/Charges;
if groupnumber = 1 or
Refunds/Charges < minsum
then
minsum := Refunds/Charges;
diffsum := maxsum-minsum

 

[lbass]

You could create two running totals {#chg} and {#ref} that sum amount, with an evaluation formula like this:

{table.type} = "Charges" //or "Refunds"

Reset never. Then create a formula to place in the report footer:

{#chg} - {#ref}

Or you could use variables by placing the following formula in the group section:

whileprintingrecords;
currencyvar chg;
currencyvar ref;
if {table.type} = "Charges" then
chg := sum({table.amt},{table.type});
if {table.type} = "Refunds" then
ref := sum({table.amt},{table.type});

Then in the report footer, use a formula like this:

whileprintingrecords;
currencyvar chg;
currencyvar ref;
chg-ref

-LB