RANGE SUM function is not working if i use two times

[#1]

HI

I have scenario

I am using rangesum function for one input column

Rangesum(above(sum(Sales_Impact),0,240))  (Sales_Impact column is input column)

It is working fine

But i want use one more rangesum like below

(Sales+Rangesum(above(sum(Sales_Impact),0,240))+Rangesum(above(sum((((Sales+Rangesum(above(sum(Sales_Impact),0,240)))*$(SalesAnnual Growth Rate))/100)),0,240)) )

If i use two times it is not working.

Please do the needful

Actual scenario is

I need to generate forcast data using above formula

Date                  sales

2016-JAN-01    1200

2016-FEB-01     1400

2016-MAR-01    1500

2016-APR-01     1750

2016-MAY-01       1800

2016-JUNE-01    2000

2016-JULY-01      2150

Forcast

2017-AUG-01      2150+Rangesum(above(sum(Sales_Impact),0,240))+                           Rangesum(above(sum((((2150+Rangesum(above(sum(Sales_Impact),0,240)))*                                                                           

$(SalesAnnual Growth Rate))/100)),0,240)) ))

here it is $(SalesAnnual Growth Rate) is inputbox  which is avaraible.

Thanks

Thiru

[sunny_talwar]

Was this not a good solution here?

Re: Generating forecast data

[#3]

Hi Sunny,

It is a good solution.but since i am new to qlikview and my code is bigger and your code is a little big.SO not able to under stand how to implement in my scenario

Any way i am trying now.i will let you know once it is done

Thanks

Thiru

[sunny_talwar]

Sure thing