Formula for % Change

[Lisa5781]

In my subreport, I need to provide the % change from year to year. I have five years worth of data, but only need to report the % change on the last two years. My years are defined on certain fiscal year criteria (in it's own formulas). Can anyone help?

 

[synapsevampire]

Please post technical information:

Crystal version
Database/connectivity used
Example data
Expected output

What is being compared, and at what section in the subreport?

If you're grouping by the year and the subreport is returning 5 years of aggregates, you'll use shared variables to house each and pass them on to the next group, however if the subreport is using 5 fields with the years already defined as 5 fields, the method is different.

Solutions are based on the data, there isn't a generic database.

-k

 

[Lisa5781]

Crystal Version: 10.0
Database/Connectivity Used: SQL Server database using OLE connection
Example Data located in subreport report header:

FY 2001 FY 2002 FY 2003 FY 2004
Form F 1,114 1,558 1,562 675
Form SC 527 1,058 1,033 425

Expected Output:

FY 2001 FY 2002 FY 2003 FY 2004
% Change 02-03 % Change 03-04
Form F 1,114 1,458 1,562/7.1% 675/-56.7%
Form SC 527 958 1,033/7.8% 1425/37.9%

The forms are grouped by year based on criteria established in a formula.
if {FormF.CYCLE_PSTD}>= "199940" and {FormF.CYCLE_PSTD}<= "200039" then "FY 2000" else
if {FormF.CYCLE_PSTD}>= "200040" and {FormF.CYCLE_PSTD}<= "200140" then "FY 2001" else
if {FormF.CYCLE_PSTD}>= "200141" and {FormF.CYCLE_PSTD}<= "200240" then "FY 2002" else
if {FormF.CYCLE_PSTD}>= "200241" and {FOrmF.CYCLE_PSTD}<= "200340" then "FY 2003" else
if {FormF.CYCLE_PSTD}>= "200341" and {FormF.CYCLE_PSTD}<= "200439" then "FY 2004" else
if {FormF.CYCLE_PSTD}>= "200440" and {FormF.CYCLE_PSTD}<= "200539" then "FY 2005" else ""