Rod, becasue we are through say April of the current year, we would need to get Jan-April for this year, and then go the previous years record, and grab 12 months of that year. Add the two together, and then Average.
So if I the first 4 months is 1000, the average is 250.
The previous 12 months is 5000, with an average of 416.00
But what I really need is 1000 plus 5000 = 6000 and in this case divide by 16 months. Average - 375.00
Using the avg function you need to tell it the complete series. But I can't get the complete series in one statement to do an Average. If I was able, then it would automatically knows its 16 months. I can't sum up the totals and then avg, because its only total and no months.
So basically I need to somehow read multiple records that include x months and average those.
Hope I am clear? Thanks, Mark
