7 Replies Latest reply: Jan 23, 2013 10:31 AM by Adam Abwat-Johnson RSS

    Forecasting Trend Information

    Adam Abwat-Johnson

      Hi All,

       

      Been scratching my head over this one this morning. I am currently trying to figure out how to generate trend figures for 2013 based on some figures I've made up for 2012.

       

      I know I can set the chart I'm using to draw a trend line and extend this out for another 12 month (although it doesn't show the x axis values) and also I've read some posts on using linest functions but I'm guessing I can't use these in the script. Ideally I would like to be able to generate actual rows using script to determine these values.

       

      I have attached the qvw I've started playing around with. If anyone has any help it would be appreciated.

       

      Regards,

       

      Chris