4 Replies Latest reply on Mar 14, 2017 1:36 AM by Mohamad Russzaimie

    Continue running_avg sum without data in that month

    Lucie Brett

      Hello

       

      Quick question (hopefully), I have a line graph showing a series of running_avg sums however for the last month I don't have a value as there weren't any sales. This isn't a bad thing as such - I would just want to continue the line with either what last month's value was or 100%. Can anyone help me with the formula to continue the lines?

       

      Thanks in advance

      Lucie