2 Replies Latest reply: Apr 24, 2014 1:31 AM by Sergey Makushinsky RSS

    How to Load Ending Value of Previous Month to Beginning Value of Current Month?

      I have a really complex sets of analysis that doing this at the back end would save a lot of time and effort.

      So, here it goes. I have two tables: one containing the values(COMPANY,END_VALUE,PERIOD_ID) and another for the periods(YEAR,QUARTER,MONTH,PERIOD_ID) joining at period_id.

       

      Thanks.