Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rolling total formula

Status
Not open for further replies.
comdisco

comdisco

Programmer
Joined
Nov 3, 2003
Messages
5
Location
GB
Can anyone tell me the syntax to calculate the last 12 months rolling total. The report parameters are period e.g. 01, 02, 03 etc and a year parameter. If the user selects period 06 in 2003 then I want the total to be for the last 12 periods e.g. period 01 - 06 in 2002 and periods 01 - 06 in 2003.

I'm a bit stuck on the syntax so any help greatly appreciated......
 
Sort by date Sort by votes
Please ignore this as I made an obvious mistake, have added another thread....
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
355
Corinne30
Corinne30
Corinne30
  • Locked
  • Question Question
Running total based on beginning parameter value
Replies
0
Views
357
Corinne30
Corinne30
T
  • Locked
  • Question Question
Date comparison Formula
Replies
2
Views
2K
TPG_IT
T
D
  • Locked
  • Question Question
Running total from a subreport only showing last value
Replies
4
Views
1K
doodledump
D
Corinne30
  • Locked
  • Question Question
Division of currency formula with/without rounding
Replies
7
Views
1K
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top