daily running average to break on the quarter?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • beaudreaux
    New Member
    • Feb 2010
    • 9
    #1

    daily running average to break on the quarter?

    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] & "#")
    Tags: None
    • MMcCarthy
      Recognized Expert MVP
      • Aug 2006
      • 14387
      #2
      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.

        Comment

        • beaudreaux
          New Member
          • Feb 2010
          • 9
          #3
          Originally posted by msquared
          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.
          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] & "#")

            Comment

            Previous template Next
            Working...