Calculating % change from values in one column

EmmanuelMash

Hi Legends

Thought I should just update you on this. With all the input you provided I decided to tackle it as below:

To calculate the growth column, I duplicated the result column and filtered it by the minimum factor or lowest factor which as I mentioned is our starting point (Call it static result). I then summed it so that it repeats for all rows.I then used the growth formula which I typed wrong above should have been ((result - static result)/ static result) * 100.  Problem solved!!!

Thank you all !!!

Gianni Ceresa

Can you please close the thread? (I guess "assumed answered" is the best matching as the answer is that you asked something else ...)

[Deleted User]

As usual love for the direct replies but none for conceptual ones dealing with understanding things :-P