Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Calculating Rolling Price Change

Hi

I'm new to Crystal Reports and am having trouble creating a field showing price change over time. For example:

Town Year Quarter Price

A 2003 1 1000

B 2003 1 900

C 2003 1 790

D 2003 1 1250

A 2004 1 1900

B 2004 1 1300

C 2004 1 800

D 2004 1 150

A 2005 1 1950

B 2005 1 1550

C 2005 1 1230

D 2005 1 1890

A 2003 2 800

B 2003 2 1900

C 2003 2 1650

D 2003 2 1800

A 2004 2 900

B 2004 2 700

C 2004 2 800

D 2004 2 2000

A 2005 2 1560

B 2005 2 800

C 2005 2 2300

D 2005 2 2290

What I need to do is show the average price growth for all the towns for each quarter compared to the same quarter the previous year.

I.E in Q2 2005 price growth from Q2 2004 is ((229023008001560)/4)/(1890123015501950)/4).

Is this possible?

Not what you were looking for? View more on this topic or Ask a question