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

conditional running sum formula error

P: 9
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 Guarentee Daily QRY]","Date Between #" & DateAdd("d",Datediff("d",if("d",if(month[date]<4,dateserial(year[date],1,1),if(month[date]<7,dateserial(year[date],4,1),if(month[date]<10,dateserial(year[date],7,1),dateserial(year[date],10,1))),[Date]) & "# AND #" & [Date] & "#")

Thank you
Feb 3 '10 #1
Share this Question
Share on Google+
2 Replies

P: 298
I am not an expert but the double quotes around the two field names don't seem right, try removing those ...

Expand|Select|Wrap|Line Numbers
  1. =DAvg("[Strght Avg Abdn%] ","[Service Guarentee Daily QRY]",

This is a complex if not confusing formula. You should try putting constant values to help you troubleshoot.
Feb 3 '10 #2

P: 9
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 result
Feb 3 '10 #3

Post your reply

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