ContributionsMost RecentMost LikesSolutionsRe: 2 Month or Quarter Rolling averageHi Mark Just a note to say thank you for the solution you suggested, it worked perfectly. Cheers Matthew ------------------------------ Matthew Kearns ------------------------------ Re: 2 Month or Quarter Rolling averageThank you Mark - I will give this a go and let you know. ------------------------------ Matthew Kearns ------------------------------ 2 Month or Quarter Rolling averageHi Folks I have been struggling with this issue. I have a series of invoices, recorded in an Invoice table. These are summarized by reporting quarter in a parent table. From this one is able to see the various types of spend as a percentage of total spend per quarter. The next step is that we need to look at the rolling average of current quarter and previous quarter as a percentage of a target. The quarters are linked to defined dates. The requirement is as follows: Average spend for Q1 plus average spend percentage for Q2. Then the average spend percentage for Q2 and Q3. This continues over 80 quarters. Does anyone have any pointers on how to do this? Thank you ------------------------------ Matthew Kearns ------------------------------ Re: Reporting against targets with results generated from multiple tables. Thank you Coach Would the fields above be created in the targets table or would an additional table be required? The targets remain consistent over the full period, would one still require the additional 8 fields for the quarter targets?Reporting against targets with results generated from multiple tables.Hi - Also new to Quickbase. I have scenario where we record invoices by supplier. We have created a table with all the supplier details, thereafter a second table with all the invoices received from the respective suppliers using a relationship table. This part is working perfectly. From there we have created a report that summarises the spend by quarter according to the fields required. The final strep in this is that we now need to apply the quarter summaries against targets set by our customer. All the the targets are fields exist in a table. Does any other user out there have any idea on how we could accomplish this? Thank you