then all you need to do is divide your running total by the running count...

 

HTH

 

You want a average for each rep that is the (YTD sales / months YTD), at least that is what I thought you said.

 

If this is so, all you need to do is determine how many months have passed in the fiscal year. The only question would be complete months or partial.

 

In January, you are 1 complete month into the fiscal year, or 2 if you include January....

or am I missing your intent?

 

 

shared numbervar mnths;

local numbervar x :=month({?dateParameter});

if x < 12 then

  mnths := x +1;

else

  mnths := 1;

mnths

 

now just use the variable mnths to divide your reps total YTD sales.

 

 

As to how to use it:

where you want the average to be calculated you would add:

shared numbervar mnths;

... your code

repsTotalSalesYTD / mnths

 

which parts don't you understand?

basically I declare some values I want to use, I use the date parameter that your user has entered to determine what month it is (month({?dateparameter}). If the month is not december (x<12), I add 1 to it, as that is the number of month in the fiscal year that have elapse. If it is December (x=12), then only 1 month has occurred.  I stored this value in variable that is accessible from anywhere in the report.  Later when you want to use the value, you just tell the report what value you want to use (shared numbervar)

 

HTH