Formula for Percent Change Between Two Years

Posted on 2010-01-05
Last Modified: 2012-05-08
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.
Question by:Chopp
    LVL 100

    Expert Comment

    Basic formula
         (Sum(Year2) - Sum(year1)) / Sum(year1)


    Author Comment

    Thank you, mimcc.

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

    LVL 100

    Accepted Solution

    SAme basic formula just use the totals for the month.


    Author Closing Comment

    Thank you, mimcc

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    This video discusses moving either the default database or any database to a new volume.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now