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!

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

Calculate Growth % between 2 periods

Status
Not open for further replies.

beth4530

Technical User
May 5, 2011
44
US
I have a clients served report in CR 2008 that I run each quarter.
I enter a start datetime and an end datetime. The counts are cumulative and are grouped by a fiscal year formula based on the months within the date range entered.
I'd like to be able to enter the current fiscal year date range, such as 7/1/2013 to 3/31/2014 for Qrter3 and see a % comparison to last fiscal year through Q3,
7/1/2012 through 3/31/2013.


 
If I were doing something like that I would set up two separate date range parameters. Then it would be quite easy to set up Running Totals sum up whatever you need to total based on the dates, then compare the two to get your percentages.

It also gives you more flexiblity, you can compare first quarter to third quarter, etc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top