Question

Hi, I am trying to forecast investments into the future using the 'Projected' columns in the screenshot below.

Let's use the 'Kyle Projected Super' column for example. I have an initial figure in the year 2017. I would then like that figure to increase by 5% and be displayed in the row below, but in the same column.

Is this possible?

Thanks.

Answer 1

It is not, you will need a new column to increase the 5%. Formulas and rollups work by row and yo can't compare them to other rows in the same column.