Liveware Publishing Support Forum

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.

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

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