Results 1 to 2 of 2

Thread: Formula error

  1. #1
    Join Date
    Jan 2008

    Unanswered: Formula error


    I have 2 formulas which holds a value for the current and previous year
    Product_CY and Product_PY
    I want to add another formula that calculates the growth between the
    two years, I tried Product_CY - Product_PY / Product_PY
    The answer I get is wrong, and not sure if it is to do with the groups in my report.
    I have 3 groups CustomerGroup, Region and CustomerName which is the detail
    and I place my formulas in the CustomerName group header.

    Any ideas?

  2. #2
    Join Date
    Aug 2010
    I don't quite understand what you want to do. What is Product_CY and Product_PY? What has it got to do with years?

    Can you give an example?


    Based on your formula, I'm guessing if
    Product_CY = 2010
    Product_PY = 1910

    You want to know the % of growth?

    If so then the formula should be
    (2010 - 1910) / 1910 = 5%

    The way you put your formula it turns out to be 2010 -1910 / 1910 = 2010 - 1 = 2009

    Did I get this right?
    Last edited by borisovr; 08-03-10 at 02:59.

Posting Permissions

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