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

Setting a starting value for Running_Sum calculation

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.

• 1. Re: Setting a starting value for Running_Sum calculation

Hi,

I don't know your data structure. Here I've used below attached data.

Is that what you wanted? Just create a calc field and compute on Month.

workbook (version 9.3) attached for your reference. Let me know If this help.

Mahfooj

• 2. Re: Setting a starting value for Running_Sum calculation

Hi,

Thanks for getting back.

I think I confused things a little, so I've made some changes to my original question to make it clearer. Please let me know if that makes more sense.

• 3. Re: Setting a starting value for Running_Sum calculation

Let me know If this help

Workbook (public version 9.3) has been saved in my profile. link has been mentioned below. Have a look

Mahfooj