beaudreaux
Last Activity: Oct 4 '10, 01:49 PM
Joined: Feb 2 '10
Location:
-
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... -
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... -
I may have misunderstood the question. The month to day is the timeframe of the data I am calculating. I have this calculated already but I need to be able to reference the prior year data for the month to date. So I need to get the data that would show 2/1/09 - 2/24/09 (for current examle of time frame)Leave a comment:
-
It is a running sum calculated from the start of a month to the current day of the month and would start over each month. Example 01/01/10 - 1/2/10, 1/1/10 - 1/3/10, 1/1/10 - 1/4/10, 1/1/10 - 1/5/10 and so on until the end of the month. I have this already calculated but I need to get the numbers of the MTD for the prior year (which has already been calculated). I need to some how reference that prior year data in my report.Leave a comment:
-
Sorry for the confusion. I will try to explain further here. I have a query Service Guarentee QRY with a field named Occpncy Rate Skill Level. From this I have a report that shows the daily volume, a month to date. I need to add a third field in the report that will show what the month to date on that day for the previous year was. Each would have a calculated result.
Day (1/25/10) MTD(1/1/10-1/25/10) MTD...Leave a comment:
-
previous data
I may not be putting 2 & 2 together. I did get to show me the date one year ago. But, how do I get it to show me the data from a year ago? I want the report field to show the previous year data (year to date). I'm not sure if I can reference the field I already have that is doing the calculation already and have it display the previous year?Leave a comment:
-
dateserial for previous year??
I am needing to calculate a month to date for the previous year in a report. Example: today is 02/18/10 and I have a month to date for today(current year). I need the report to also show month to date for 02/18/09. I believe I would be able to manipulate my current formula that figures the month to date for the current year, but I have been unsuccessful so far. I have the current year, month to date formula of:
...Code:=DAvg("[Occpncy Rate -
That did not work, that particular part is identifying the field and the query the field is in. Also tried using as the expression builder would place into the formula of: [Service Guarentee Daily QRY]![Strght Avg Abdn%]. Still no resultLeave a comment:
-
conditional running sum formula error
I have the followinf formula listed below and I am receiving the message: "The expression you entered contains invalid syntax. You may have entered an operand without an operator." I am not sure exactly where is the problem. Any help would be greatfull. This is in a report and I need this to be a conditional running sum that figures for each quarter and starts over at each quarter.
=DAvg("[Strght Avg Abdn%] ","[Service...
No activity results to display
Leave a comment: