2 Month or Quarter Rolling average
Hi 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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is one solution.
Make a relationship between Quarters to Quarters (ie related the table to itself). Let it create a field for related quarter and then rename that to be call Related Previous Quarter. If the Key field if Quarters is [Record ID#] then find a field on the Quarters record look it up and ands set edit [Related Previous Quarter] to set that as the Proxy field.
Then make that a required field on the Quarters table and hand edit the 80 records to relate each Quarter to the Previous Quarter. Then lookup anything that you need like total invoice value and make your formulas.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a relationship between Quarters to Quarters (ie related the table to itself). Let it create a field for related quarter and then rename that to be call Related Previous Quarter. If the Key field if Quarters is [Record ID#] then find a field on the Quarters record look it up and ands set edit [Related Previous Quarter] to set that as the Proxy field.
Then make that a required field on the Quarters table and hand edit the 80 records to relate each Quarter to the Previous Quarter. Then lookup anything that you need like total invoice value and make your formulas.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thank you Mark - I will give this a go and let you know.
------------------------------
Matthew Kearns
------------------------------- Hi Mark
Just a note to say thank you for the solution you suggested, it worked perfectly.
Cheers
Matthew
------------------------------
Matthew Kearns
------------------------------
