Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

S Curve Dvelopment - Forecast Line

Hello,   I am creating a Progress S Curve plotting a baseline, actual and forecast values. I have the running cumulative lines working fine with one exception. My forecast line does not meet my act...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous -

Please see this Quick Measure tutorial. 

The basic idea is to determine the latest relevant date for Actuals and use that date to calculate forecast. In your case, you can substitute the Cumulative calculation for the YTD calculations.

Hope this helps,

Nathan

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous I will have to try it out. The only thing i noticed at a quick glance is that it uses max date from the sales (in my case actuals). My data is live linked so continuously has more data but i worked around it by making the values 0 if they are above the first date in the forecast and then added the forecast values to them. For most weeks that is 0 but it enables my final weeks to close the gap. and overlap the lines with the forecast line in front

     

    Will definitely give your method a shot when i get a chance though. Looks a lot cleaner