Charting Print Time formula Values

[Ayush15690]

Hi,
I am using Crystal Reports XI and I am trying to Print this formula shared numberVar x ;
shared numberVar y ;
shared numberVar z ;
shared numberVar t;
shared numberVar u ;

If {Command.weekno} =1 then
x :=Sum({Command.duration},{Command.weekno})/1
else if {Command.weekno} = 2 then
y :=(x+Sum({Command.duration},{Command.weekno}))/2
else if {Command.weekno} = 3 then
z :=(y*2 +Sum({Command.duration},{Command.weekno}))/3
else if {Command.weekno} =4 then
t :=(z*3 + Sum({Command.duration},{Command.weekno}))/4
else if {Command.weekno} = 5 then
u :=(t*4 +Sum({Command.duration},{Command.weekno}))/5

I want to plot above values on line graph against WEEK NUMBER(A month has 5 weeks). I tried every possible method given. I used the sub report also but it didn't seem to be working. When I try using a formula to split the array of the values of above formuala in subreport indexed by RECORD NUMBER it throws an error :-The index should be between 1 and Size of array. Please help as I have a deadline to meet.

 

[Ayush15690]

People ,Please suggest how can I chart the above formula in crystal report.