16 Replies Latest reply: Jan 4, 2012 7:39 AM by Vijay Kumar RSS

    Future Simulation without existing data, based on past data?

    Martin Vierling

      Hi,

       

      I have e.g. turnover data for the last years. The calendar information is hold in a calendar table, going from e.g. 2000 to 2020. I would like to show in a diagram the turnover for the last years by period, AND how the turnover will develop in the next year based on the development of the current year. For the next year I do not have data.

      I thought about using the calendar table for the dimension, and splitting the formula at today. For all dates below today I use the information I have, for all future dates, I calculate based on the values of this year. For example turnover growed by 2% from January 2011 to February 2011, by 3% the next month, and so on. So how does it develop for January 2012, based on the turnover in December 2011, growing by the calculated 2%.

       

      When I try that, I am told that there are no information available... Do you have an idea or example for that?

       

      Thanks a lot,

      Martin