3 Replies Latest reply on Jul 29, 2016 9:08 AM by Mahfooj Khan

    Setting a starting value for Running_Sum calculation

    sina.d

      Hi All,

       

      I'm using a running_sum calculation to subtract two Measures for each month. [Opened]-[Solved] which should return the number of Outstanding calls.

       

      I need to know if it's possible to start the calculation at a specific value i.e. I need it to start with the value of 27, and then it can continue with cumulative count. See table below:

       

       

      OctoberNovemberDecemberJanuaryFebruary
      [Opened]18911014015385
      [Solved]20012013116090
      [Outstanding calls] * this is what the calculated field should return1661583

      I've just added this row to show you how how [Outstanding calls] calculation should be calculated.

      It's using the previous months [Outstanding calls] value as a carry over for next months calculation. As October has no previous months, I need it to start with 27, as a 'fabricated' carry over.

      (27+189-200)(16+110-120)(6+140-131)(15+153-160)(8+85-90)

       

      The months is [date] dimension to be used in the Columns shelf.

       

      Hope this makes sense. Please let me know if further info is required.

       

      Thanks in advance.