Calculating Percent Change

[Thibaud_Donzier]

Hi,

I am trying to calculate the percent change between two numbers in the same column, just different rows. If I were doing it in Excel, it would be =(B9-B3)/B3 but I can’t seem to find the way to make this formula work in Coda. Is it possible?

Thanks in advance for your help !

[Dalmo_Mendonca]

If it’s just specific rows, you can reference them directly with @. See:

Otherwise, if you’re looking for a more general form, this post has several methods:

Visual Position of the row in table

Hey there, would you have a tip to use this in a grouped table? I actually get this : [image]

[Jean_Pierre_Traets]

Dear @Dalmo_Mendonca,

With respect for your input, you’re showing again that it’s as simple as that to take any cell by using "@ " . “column name”, and make the calculations as desired.

@mallika - another suggestion to add to the templates

[Thibaud_Donzier]

Hello,
Thanks for your answer but I don’t get it

How can I creat two formulas, one to calculate the increase in figures and the second in percent between each row ?

Thanks in advance.

[mallika]

@Thibaud_Donzier - currently it is not easy in Coda to do this . But there are posts that tell you how to go about it - Adding values from previous rows