Crosstab Percentages per Month 1

[elansienna]

I am using CR version 10 with Oracle on the backend. I am attempting to create a crosstab in the report footer area to show totals and percentages by month from formulas created: Total_incidents (count of all incidents); Response_Incidents (count of incidents meeting response SLA) and Resolve_Incidents(count of incidents meeting resolution SLA).
For the crosstab, which would look as follows:

6/2007 7/20007 8/2007 9/2007
Total Incidents 3 4 5 6
Total Response 3 2 5 3
% Response 100% 50% 100 50%
Total Resolution 2 2 3 2
% Resolution 66.67% 50% 60% 33.33%

So, essentially the column date field grouped by month and sum total of the formulas in the summarized field of the crosstab. My problem is creating a formula for the percentage response and resolution to total incidents. Your advise on the best solution would be appreciated.

 

[lbass]

Add the count of response incidents field as a summary twice. Do the same for the count of resolve incidents. Then in preview mode, select the Total Incidents summary->right click->format field->common tab->suppress->x+22 and enter:

whileprintingrecords;
numbervar tot := currentfieldvalue;
false

Then select both the second of each of the remaining summaries simultaneously->right click->format field->common tab->display string->x+2 and enter the following:

whileprintingrecords;
numbervar tot;
totext(currentfieldvalue%tot,2)+"%" //2 for two decimals

-LB

 

[elansienna]

First and foremost, thank you for the immediate response! You are a Godsend!

I did exactly as you mentioned, but something seems to be wrong with the percentage calculation as I get the following in a sample.


6/2007 7/2007 8/2007
total incidents 88 200 81
Total Response 75 176 73
Percentage Response 100.00% 100.00% 100.00%
Total Resolve 78 166 74
Percentage Resolve 104.00% 94.32% 101.37%

What could be wrong?

 

[lbass]

It looks like you added the first formula on the total responses, instead of on total incidents. Please reread my post. The second formula should be used for both the resolve and the response summaries.

-LB

 

[elansienna]

I will go back and redo. As always thanks for your help!