Cross Tab - Adding and Extra field

[DeviousDi]

Hi,

I have a cross tab report set up like so:

[pre] QueryStatusDesc Total

Dispute Status Sum@Days Sum@Days
CountQuery.id CountQuery.ID [/pre]


Under the CountQuery.id total I want to add my own calculation, the average. Basically the figure for sum@days / figures for CountQuery.id. So it would look like this:

[pre]
Desc 1 Desc2 Total
Pre-defined Days 30 45 75
Count 3 4 7
(new field) Avg 10 11.25 10.71 (This being 30/3, 45/4, 75/7)

Fixed Days 50 30 80
Count 5 3 8
(new field) Avg 10 10 10

Totals Days 80 75 155
Count 8 7 15
(new field) Avg 10 10.71 10.33


[/pre]

I've tried using the average function, but it doesn't bring back the correct figures, as I think it counts the records that are also 0, which I don't want.

I've also tried to insert a formula, but this just 'adds' everything up, and again I don't want that.

Is there another way this can be done? I'm using SAP CR XI

Thanks

Di