I want to calculate 25% growth over prior year's sale (by month). The way I am solving this currently is by multiplying (sale)*1.25; this works fine for sale values that are positive but for those that are negative I get that the 25% growth is more negative than the the sale amount. I don't want to tell the salesperson that I want them to sale even less than they have sold in the prior year.
Prior Year Jan - 40000 Feb - -20000 (negative because they can have sales taken away)
Current Year - I want the salesperson to have a growth of 25% over their prior year amount Jan - 40000*1.25 = 50000 Feb - -20000*1.25=-25000 (based on my calculation they should actually be at -15000, this is 25% growth from their -20000)
I am trying to find a solution that works for both scenario as it needs to go into a equation/formula.
Thank you very much for your help!