My data runs through 2018. I then have projected year over year growth percentages based on data in another table for 2019, 2020, 2021.
What I would like to do is take my amount from 2018 and apply the growth percentage for 2019 from my other table. Then for 2020, it should take the result of this measure and then apply the year over year growth percentage for 2020, etc..
So for example my amount for 2018 is $100. In another table, it says the year over year growth percentage for 2019 is 20%. So the result for 2019 should be (100 * 1.2) = 120. Then for 2020 the growth percentage is 5%. So it should take the result for 2019 ($120) and apply the 2020 growth percentage (120 * 1.05) = $126.
Any ideas on how to do this? I guess it would be similar to a compund interest calculation sort of.
