Help

Creating Goals by Increasing a Number by a Set Percentage

Topic Labels: Formulas
682 1
cancel
Showing results for 
Search instead for 
Did you mean: 
nicole_e
4 - Data Explorer
4 - Data Explorer

I am trying to generate sales goals in a formula, I have a column with the previous years result (manually entered), I have a % column with my growth target but I cannot figure out how to create a column with a formula that takes the previous result ($) and adds to growth target (%) to create a goal ($)

Screenshot 2023-05-31 at 9.20.14 PM.png

1 Reply 1
Stephen_Orr1
10 - Mercury
10 - Mercury
You could write this as
 
{2022} + {2022} * {Target}
or
{2022} * (1 + {Target})
 
or record your target increase as 140% and keep your formula as-is:
{2022} * {Target}

Hope that helps!