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.

      withoutfullaccumulation.png

      Example Chart: Without Full Accumulation

       

      withfullaccumulation.png

      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.