Formula for Percent Change Between Two Years

Happy New Year Experts,

Can you provide me with the formula(s) to show the percent change between two years.  The data I need to evaluate will be a number and I will need to use the formula in Crystal Reports version 11, and in Microsoft SQL Server 2005.

Thank you.
~Chopp
ChoppAsked:
Who is Participating?
 
mlmccCommented:
SAme basic formula just use the totals for the month.

mlmcc
0
 
mlmccCommented:
Basic formula
     (Sum(Year2) - Sum(year1)) / Sum(year1)

mlmcc
0
 
ChoppAuthor Commented:
Thank you, mimcc.

What would the formula look like for each MONTH per year ?

~Chopp
0
 
ChoppAuthor Commented:
Thank you, mimcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.