12 Replies Latest reply: Apr 25, 2013 4:13 AM by Gerald Tagudando RSS

    Calculate 1 year when only 1 month is selected

      Hi Guys,

       

      I would like to ask for your help regarding my problem.

      Please let me explain my problem brielfly:

       

       

      This is my data for 2 years:

       

      2011:

      GroupJanFebMarAprMayJunJulAugSepOctNovDec
      A100110120130140150160170180190200210
      B150160170180190200210220230240250260
      C200210220230240250260270280290300310

       

      2012:

      GroupJanFebMarAprMayJunJulAugSepOctNovDec
      A8090100110120130140150160170180190
      B130140150160170180190200210220230240
      C180190200210220230240250260270280290

       

       

      Formula:

      Sales Ratio = Sum Sales this month divided by Sum Sales of the whole year

      (ex. If user selects Aug-2012,then Sum (Sales for Aug 2012) divided by Sum (Sales from Aug 2011 to Aug 2012).

       

      Catch:

      User wants only to select Aug 2012 in the listbox. Now the user wants to see the result of Sales Ratio. The answer should be: 0.080213903

       

      Question:

      What will my expression look like?

       

      Thanks in advance and godbless!

       

      Gerald