2 Replies Latest reply: Jun 21, 2013 5:37 AM by test test RSS

    Populating Null Values in Month with Value Previous Month

      Hello,

       

      I have the following chart, to display the total stock over a period of time (where the stock changes cause of mutations for each article that are calculated).

      The stock value is calculated by date. So the month is a total sum of stock in that month.

       

      Problem is, when an article does not have mutations in a certain month, stock value is 0. So in some months the current stock values are missing.

       

      Is there a way to populate the empty values with the value of last month?