Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross Tab - Adding and Extra field

Status
Not open for further replies.

DeviousDi

MIS
May 23, 2013
57
GB
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

[hammer]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top