Hi all,
I again needs some help and am somewhat stuck.
I have a report which is grouped by month and then sorted by year. So we can compare work flow for the same month over years. Each month then has a total of unprocessed information. I have tried to demonstrate it in the table below.
<tbody>
</tbody>
The unprocessed total is a calculated field within the "Year" Footer of the report and the calculation is within the report itself.
I have been asked to have the unprocessed total carry forward. i.e. Job 3 in Month 1 2012 had 24 unprocessed records, so Job 3 in Month 2 2012 should be the 24 from Month 1 plus the 15 in Month 2 giving a total of 39.
This needs to work for Months 1 to 12 and then roll over to Month 1 in the next year.
I have tried to think about it and am leaning towards adding something to something like count the month before to the calculated field, but I have a headache setting in and this is beginning to be over my head......can anyone help??
Thanks in advance
I again needs some help and am somewhat stuck.
I have a report which is grouped by month and then sorted by year. So we can compare work flow for the same month over years. Each month then has a total of unprocessed information. I have tried to demonstrate it in the table below.
Month | Year | Queue | Job1 | Job2 | Job 3 |
1 | |||||
2012 | Post | 904 | 63 | 24 | |
Processed | 376 | 47 | 0 | ||
Unprocessed total | 528 | 16 | 24 | ||
2013 | Post | 544 | 70 | 26 | |
Processed | 308 | 24 | 0 | ||
Unprocessed total | 236 | 46 | 26 | ||
2 | |||||
2012 | Post | 760 | 139 | 15 | |
Processed | 252 | 137 | 0 | ||
Unprocessed total | 508 | 2 | 15 |
<tbody>
</tbody>
The unprocessed total is a calculated field within the "Year" Footer of the report and the calculation is within the report itself.
I have been asked to have the unprocessed total carry forward. i.e. Job 3 in Month 1 2012 had 24 unprocessed records, so Job 3 in Month 2 2012 should be the 24 from Month 1 plus the 15 in Month 2 giving a total of 39.
This needs to work for Months 1 to 12 and then roll over to Month 1 in the next year.
I have tried to think about it and am leaning towards adding something to something like count the month before to the calculated field, but I have a headache setting in and this is beginning to be over my head......can anyone help??
Thanks in advance