By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,985 Members | 2,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,985 IT Pros & Developers. It's quick & easy.

daily running average to break on the quarter?

P: 9
I have a report that is grouped by Quarter and have the following to give me a daily running average and to break/reset each quarter. However, the daily runnning average does not reset after the end of each quarter. Any help on why this would not be resetting at the start of each quarter for the daily running average? SO my end result would be a daily average through the end of the quarter and the last day of the quarter would be the overall average for that quarter. Here is the formula I am using in the report

=DAvg("[Strght Avg Abdn%]","[Service Guarentee Daily QRY]","Date Between #" & DateAdd("q",-1,[rptDate]) & "# AND #" & [rptDate] & "#")
Apr 20 '10 #1
Share this Question
Share on Google+
2 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
It's difficult to say but I would take a different approach. Assuming "Service Guarentee Daily QRY" is the base query for your report then in the group footer just put a control as follows ...

=Avg([Strght Avg Abdn%])

This should only pick up values displayed in that quarter.
Apr 22 '10 #2

P: 9
@msquared
That is correct, it is the base query for my report. Gave that a try with the group footer and control. It actually gave me the same results I already have. It is funny cause the result of each quarter is correct, just the day to day figures are not. I need to be able to look at it during the month to ensure I am on track for the end quarter results. I have a monthly the works perfect with a slightly different formula and the report grouping on a monthly basis. I tried this formula & having the report group on the quarter and the daily is still wrong. Here is the other formula so you can see it to see if there may be some other ideas.

=DAvg("[Strght Avg Abdn%] ","[Service Guarentee Daily QRY]","Date Between #" & DateAdd("d",-Day([Date])+1,[Date]) & "# AND #" & [Date] & "#")
Apr 23 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.