AdamKeever1
Qrew Commander
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Rolling 3 Month Average
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 ------------------------------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. If you want to do 6 months average, just change the -2's to -6's for the month string. var text QUERY = "{7.OAF.'" & ToDate( //create 2-digit month If(ToNumber(Month([Bill Creation Date]))=2,"12", If(ToNumber(Month([Bill Creation Date]))=1,"11", If(ToNumber(Month([Bill Creation Date]))<10,"0" & ToText(Month([Bill Creation Date])-2), ToText(Month([Bill Creation Date])-2)))) & // first day "/01/" & //create 4-digit year If(ToNumber(Month([Bill Creation Date]))<=2,ToText(Year([Bill Creation Date])-1), ToText(Year([Bill Creation Date])))) & "'}AND{7.OBF.'" & LastDayOfMonth([Bill Creation Date]) & "'}AND{9.CT.'TEXT_STRING_FILTER'}"; SumValues(GetRecords($QUERY),18)/Size(GetRecords($QUERY)) Hope you find this useful. P.S. @Sharon Faust thanks for sharing your tips on report formulas! ------------------------------ Adam Keever ------------------------------Re: Summary report in dashboard links to blank drilldown
@Matt Makris , that is odd. I just checked and the link to the summary records on a summary report opened fine for me from a new dashboard. I would open a user support ticket. Seems like a bug to me. ------------------------------ Adam Keever ------------------------------Re: Need help setting up relationship between courses and instructors
@Graesen Arnoff , for this you need what is often called a 'join table'. You could call it 'course instructors' or 'instructor courses' or something along those lines. One 'course instructors' will have many 'courses' in one relationship and will have many 'instructors' in another relationship. ------------------------------ Adam Keever ------------------------------
