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 !

If it’s just specific rows, you can reference them directly with @. See: [image] Otherwise, if you’re looking for a more general form, this post has several methods: [image] Visual Position of the row in table Tips and Hacks Hey there, would you have a tip to use this in…

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 :thought_balloon:

Hello, Thanks for your answer but I don’t get it :frowning: [54] How can I creat two formulas, one to calculate the increase in figures and the second in percent between each row ? Thanks in advance.

Calculating Percent Change

mallika October 21, 2019, 9:10pm 5

@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

Topic		Replies	Views
Formulas for Individual Cells	6	919	July 13, 2023
Reference the previous rows values to calculate incrementally	1	752	August 20, 2021
Coda Formulas - How to multiply items in the same column?	4	494	March 12, 2024
Formulas referencing different rows in the same column Doc Show and Tell	2	647	August 11, 2022
Subtract two rows within a group	3	646	June 24, 2021

Calculating Percent Change

Related topics