Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Year-over-year sales growth

Discussion in 'Information Technology' started by ron, Jul 28, 2006.

  1. ron

    ron
    Expand Collapse
    Guest

    I'm trying to add a field in a report that shows year over year sales growth.

    Imagine a table with the following fields:
    Year - Sales
    2005 $100,000
    2004 $50,000

    In a report I want to show the growth but don't know how I would build the
    expression.
     
  2. Loading...

    Similar Threads Forum Date
    USA Sikh Car Salesman Reaches Settlement With Lexus Dealership Breaking News Nov 30, 2013
    Luxury Car Sales Boom in Punjab, Haryana Business, Lifestyle & Leisure Aug 27, 2011
    India Tata Nano's Nov sales one-sixth of Oct figures Breaking News Dec 7, 2010
    UK Kachera sales opportunity ! lol Breaking News Aug 26, 2010
    Sikhism Rocket Singh - Salesman of the Year Videos Oct 29, 2009

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    I built two queries to pull the data. I based the table on the data you
    presented.

    Ron_Sales_Past --
    SELECT Ron_Sales.Year, [Year]-1 AS [Past Year], Ron_Sales.Sales
    FROM Ron_Sales;

    SELECT [Ron_Sales].[Year]+1 AS [Sales Year], Ron_Sales_Past.Sales AS
    [Current Year], Ron_Sales.Sales AS [Year Ago Sales],
    [Ron_Sales_Past].[Sales]-[Ron_Sales].[Sales] AS [Growth over last year]
    FROM Ron_Sales INNER JOIN Ron_Sales_Past ON Ron_Sales.Year =
    Ron_Sales_Past.[Past Year]
    ORDER BY [Ron_Sales].[Year]+1;

    "ron" wrote:

    > I'm trying to add a field in a report that shows year over year sales growth.
    >
    > Imagine a table with the following fields:
    > Year - Sales
    > 2005 $100,000
    > 2004 $50,000
    >
    > In a report I want to show the growth but don't know how I would build the
    > expression.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page