This is the Cross-tab
07-04 07-03 07-02 Total
agomez 16 21 21 58.00
bshane 8 56 49 113.00
ces 0 0 1 1.00
cglei 45 75 47 167.00
cpach 23 40 29 92.00
Total 92 192 147 431.00
07-02
Total Cases: 147
Total agents: 5
Avg Cases per agent: 29.40
07-03
Total Cases: 192
Total Positions: 4
Avg Cases per agent: 48.00
07-04
Total Cases: 92
Total Positions: 4
Avg Cases per agent: 23.00
In the summaries I calculate the avg cases per agent by dividing the total agentes where # of cases for that month is not equal to 0 by the total cases.
I am trying to use to follow the Charting on Print-Time Formulas paper posted in the CR site but I am having a hard time since my report uses a formula resulting from calculation over two run totals Total Cases/Total agents'.
Any suggestions?
Thanks
07-04 07-03 07-02 Total
agomez 16 21 21 58.00
bshane 8 56 49 113.00
ces 0 0 1 1.00
cglei 45 75 47 167.00
cpach 23 40 29 92.00
Total 92 192 147 431.00
07-02
Total Cases: 147
Total agents: 5
Avg Cases per agent: 29.40
07-03
Total Cases: 192
Total Positions: 4
Avg Cases per agent: 48.00
07-04
Total Cases: 92
Total Positions: 4
Avg Cases per agent: 23.00
In the summaries I calculate the avg cases per agent by dividing the total agentes where # of cases for that month is not equal to 0 by the total cases.
I am trying to use to follow the Charting on Print-Time Formulas paper posted in the CR site but I am having a hard time since my report uses a formula resulting from calculation over two run totals Total Cases/Total agents'.
Any suggestions?
Thanks