Calculating averages??

[FRED_EMMERICH_(Guest)]

I have a database where I have monthly data from various entities. I want to calculate the average of the last 12 months only. The last 12 month do not coincide with a calendar year. What is the best way to approach this? I can^t query out all but the last 12 months since I am trying to apply multiple conditions at the same time- 1) the average of the last 12 months is below a specified value, and 2) there are at least 12 months of data.

[kfleming]

So you only want the average if there is more than 12 months of data and the average meets a certain condition?____Are you printing just monthly totals on the report?____I think it can be done but I need to better understand what you need the final result to look like.____Kathleen__R&R Support

[FRED_EMMERICH_(Guest)]

Hi Kathleeen, all my data is monthly. What I have done is to set up a counter so that if the counter is less than 12, include. I then set up a total to do the average and as a condition I set the date to be after 1/1/2000 (this is more than 12 months). When I run it, I only want those with an average below a certain value. Basically, I want to know how many are less than 12 months, and how many are lower than the average. I was worried about handling those that met both criteria. Does it sound like I set it up correctly?____Thanks