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 Chris 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
Nov 3, 2003
5
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

T
  • Locked
  • Question
Date comparison Formula
Replies
2
Views
475
TPG_IT
T
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
551
doodledump
D
Corinne30
  • Locked
  • Question
Division of currency formula with/without rounding
Replies
7
Views
685
dgillz
dgillz
jlr123
  • Locked
  • Question
Crystal Formula Grand Total - Running total 1
Replies
2
Views
202
jlr123
jlr123
john432
  • Locked
  • Question
OLE Objects in your formula 1
Replies
2
Views
336
john432
john432

Part and Inventory Search

Sponsor

Back
Top