FireGeek21
Technical User
I need to show a YTD average by week. I can get a weekly average but I can't seem to average year to date and show what that YTD average looked like each week. Average is amount of time it takes to get a task done.
For example:
Week 1 average = 45 YTD average at week 1 should be 45
Week 2 average = 55 YTD average at week 2 should be 50
Week 3 average = 40 YTD average at week 3 should be 45
Week 4 average = 60 YTD average at week 4 should be 50
This is for a fiscal year that starts 7/1. I also need to display the weekly YTD average across in a crosstab so it can be exported in Excel. (WEEK 1 | WEEK 2 | WEEK 3 | Week 4 | ...etc...)
THANKS!!!
Tammy
FireGeek
(currently using Crystal Reports XI with Lawson 9.01)
For example:
Week 1 average = 45 YTD average at week 1 should be 45
Week 2 average = 55 YTD average at week 2 should be 50
Week 3 average = 40 YTD average at week 3 should be 45
Week 4 average = 60 YTD average at week 4 should be 50
This is for a fiscal year that starts 7/1. I also need to display the weekly YTD average across in a crosstab so it can be exported in Excel. (WEEK 1 | WEEK 2 | WEEK 3 | Week 4 | ...etc...)
THANKS!!!
Tammy
FireGeek
(currently using Crystal Reports XI with Lawson 9.01)