1 Reply Latest reply: Jun 16, 2011 7:00 AM by Cenny Håveland RSS

    Accumulated values (months before) for reduction of current month

    Cenny Håveland

      I have a problem with accumulation and reduction. It's hard to explain, but I've done my best in the table below. The dimensions used are Client and Closure Date. The values I get from the load script are Consumption and Produced, the rest needs to be calculated somehow.. The most important columns are the 2 last, the other are just there for explaining the problem..

      ClientConsumption closure dateConsumptionPossible reduction (80% of   Consumpt.)Produced (for reduction)Reduction this monthLeft after reduction this monthActual reduction incl. Acc.Acc. Reduction left for use
      68
      5832442010-10-01814651541541054168
      5832442010-09-018396715975970671178
      5832442010-08-0179763867663838638252
      5832442010-07-01752602815602213602213
      5832442010-06-0174359451151105110

       

       

      Please help me figure this out before I throw my pc out the window! :-)