Set Analysis to used to show 10 % increase as per current Sales by month

[alis2063]

Hi Guys,

Actually ,i need to show 10% increase of Sales  by Month which depend on 2019 sales as below  

The calculation of budget 2019 is

Jan-48566

Feb-(48566*10)/100+48566=58764

March-(58764*10)/100+58764=64641.35

[alis2063]

Hi Sunny,

why we have used log(1.1) in the scripts?

[sunny_talwar · Accepted solution]

Basically, we are doing like this

Jan - 1
Feb - 1.1
Mar - 1.1 * 1.1
Apr - 1.1 * 1.1 * 1.1

So, in order to accumulated multiplication, I am using Log function which can then be added and then brought back to its original form using exp() function.