Calculation Sales growth

[Reuven12]

Hey all,

So I got a problem. I need to calculate sales number according to percentage growth of one year.

So for example my data contain that in 2022 my sales are 400 and the growth is 10 percent. 

I want to calculate for each year how much the sales gonna be, so for 2023 440 and for 2024 484.and so on.

I can't right It on the script cause the numbers need change by the user.

Is there any way to calculate it?

[anthonyj]

Hi @Reuven12 ,

The calculation for compounding increases in Qlik uses the Pow( ) function. 

Projected 1 Year = sum(num(Amount * pow(1 + 0.1, 1)))

Projected 2 Year = sum(num(Amount * pow(1 + 0.1, 2)))

Projected 3 Year = sum(num(Amount * pow(1 + 0.1, 3))) 

etc...

I'm not sure what you meant by the numbers changing per user, but this can be a start.

I hope it helps.

Thanks

Anthony