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



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