4 Replies Latest reply: Jul 6, 2015 10:03 AM by Michael Palumbo RSS

    Problem with Full Accumulation

      I'm having trouble getting my chart to display cumulative values. Currently I have three expressions,


      1) ACTUALS: which contains values for months 1-4,

      2) FORECASTS: which contains values for months 5-12, and

      3) PLAN: which contains values for months 1-12.


      I want to show the cumulative values for ACTUALS, but have it include the FORECAST values after month 5.


      Example Chart: Without Full Accumulation



      Example Chart: With Full Accumulation


      Every time I use full accumulation it flat lines ACTUALS after APR. How can I incorporate all three expressions so the chart reads something like the following.