Rolling 3 Month Average
Here is a report formula that returns a rolling 3 month average. FID 7 is [Bill Creation Date], FID 9 is a field I am using to filter records, and FID 18 is the currency field that is being averaged....
Forum Discussion
@Adam Keever This is a cool use for query formulas.
You may want to consider using the AdjustMonth() function to create the 2 month earlier date for the query.
So,
var text QUERY = "{7.OAF.'" & AdjustMonth(FirstDayOfMonth([Bill Creation Date]),-2)
& "'}AND{7.OBF.'" & LastDayOfMonth([Bill Creation Date]) & "'}AND{9.CT.'TEXT_STRING_FILTER'}";
SumValues(GetRecords($QUERY),18)/Size(GetRecords($QUERY))
-Sharon
------------------------------
Quick Base Junkie
Quick Base Junkie
https://quickbasejunkie.com
------------------------------
Ah, thanks @Sharon Faust. That is so much better, plus it helped with another summary I was working that is by rolling quarters!
Shameless plug here, check out Quickbase Junkie for lots of amazing tips to help you be more productive in Quickbase.
------------------------------
Adam Keever
------------------------------
