dcsimg
Results 1 to 3 of 3

Thread: Date / Year variances between years

  1. #1
    Join Date
    Dec 2008
    Posts
    2

    Date / Year variances between years

    Hi, I am quite new to Olap,and have been using excel 2007 as the olap browser. I have come to a problem that I cannot solve - In fact I have been at it for the past 2 days, and frankly close to giving up.
    The problem is that I have a collumn named customer, and have a drilldown for product, and across I have 2 years for analysis.

    Customer code Value 2007 Value2008
    Products Value 2007 Value2008

    What I am after is the Value2008 less Value2007. I have tried the following formula but am getting an error The '2007' string cannot be converted to the date type.


    The output for the above is a variance, however I can live with a formula to get 2007 values, and 2008 values in a separate formula and then subtract.
    Thanks in anticipation for anyone who can help.

  2. #2
    Join Date
    Dec 2008
    Posts
    2

    Date / Year variances between years

    -- USING FORMULA

    SUM
    (([Date].[monthly analysis].[year].&[2007]),[Measures].Value
    )

  3. #3
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    A Quick Question ...

    Did you try to use the function you show, are you proposing to use it, or are you asking how we would suggest doing it?

    We'll try to help with more particulars ...

    Bill

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •