Hi,
I want to be able properly forecast the growth rate through time. Right now for Software, we select what month we’d like to grow the monthly cost and by what %. I’d like the formula to work as following:
If the month is in an actual period, don’t grow the software period until the following year (example: if we had a software planned to grow in January, for 2026 we wouldnt see any growth but in January 2027 we would see the growth rate).
Right now we have a super complex formula that really slows down the model:
is there a more simplified way to calculate a growth rate %? Below are screenshots for an example calc based on the formula above:
thank you in advance for all of the help!