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
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