How to calculate running sum for upcoming months

[montubhardwaj]

Hi All,

I need a help for figuring out running sum logic for my requirement. I have listed down my requirement below.

I have the Sales till last month and no need to worry about it. But, based on previous months sale, I have to forecast coming moth sales.

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sales

10

20

30

40

50

60

70

80

90

100

X

Y

Where X= {(Sum of all the moths so far)/No of Months so far}*No of weeks in this month

i.e. ((10+20+30+40+50+60+70+80+90+100)/10)*4)=220)

Y= {(Sum of all the moths so far)/No of Months so far}*No of weeks in this month

i.e. ((10+20+30+40+50+60+70+80+90+100+220)/11)*5)=350)

The value calculated for the month of Nov should also be included for Dec month calculations.

Thanks in advance for your advice.

[montubhardwaj]

any idea on this ?

[ester_pr]

Hi,

did you get any answers?

[nagaiank]

The answer may be too late to be useful to Sharma Sharma, but I have attached one way of doing the extrapolation.

Hope this helps.

[ester_pr]

Thank you!

[lironbaram]

hei

attach is an example of an idea

it is base on rangesum and above functions

hope it helps you

[ester_pr]

I am traying to do this on every month and it does not work

somthing like

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sales

10

20

30

40

50

60

70

80

90

100

X

x

the result should be

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sales

10

30

60

100

150

210

280

x

x

x

X

x