CR11 Crosstab: want to sum 2 fields and then divide 1

[azoe]

I have a list of charges, payments and adjustments, and the create date for the transactions. No groups.

I put a crosstab in the report footer and have a column header of the name of each month included between the start and end dates.

Now, in each of those months, using September as an example, I'd like to total the payments for September and divide that number by the total charges for September.

I also need to do a second calculation where I add the total payments and adjustments together from September and then divide that by the total charges for September.

This formula works in the report footer:
ABS(Sum ({aa_dch_PercentOfGrossCollections;1.PaidAmt}) % Sum ({aa_dch_PercentOfGrossCollections;1.ChgAmt}))

but when I put it in the summarized field of the crosstab it changes from 73.73 (rpt footer) to 5 million dollars.
I tried taking out the sums:
ABS({aa_dch_PercentOfGrossCollections;1.PaidAmt} % {aa_dch_PercentOfGrossCollections;1.ChgAmt})
but now it returns a blank.

Is it possible? Am I close?

Thank you -

 

[azoe]

Never mind. I found the answer in a Ken Hamady article:

http://www.kenhamady.com/news0407.html

Technique 2 worked for me.
Thanks