I asked Coda AI to give me help with creating a running total formula and it told me this: Yes, Coda does support the running total formula. You can use the RunningTotal() function to calculate running totals in Coda. It also told me this: To set up running totals in Coda, you can follow these st…

Generative AI, while wonderful, is prone to flights of fancy, known as hallucinations in the industry. It will rather tell you a lie, than two you know. This is an example of where AI should have just kept quiet. It is possible to have a running total in a table, but it is not as straightforward a…

Hi @Peter_Nelson , please check if that is your desired output: You can also move the rows up and down and see how the values of the running total dynamically change.

[image] Piet_Strydom: It is possible to have a running total in a table, but it is not as straightforward as on Excel. Hi @Piet_Strydom , what are the differences between a running total in Excel and a running total in Coda? I’ve never been an Excel user, so I’m curious. Best regards Jannis …

In Excel the relationship between rows are static. If you have a column of numbers you can have a running total in a column next to it, with a formula that says basically + cell above + cell to the left. In Coda, as you have shown, you need to explicitly set the column sequence. P Edit: [image] …

I came across this good explanation by the big man himself… :wink: [image] Running Total (Sum, Average, Median, etc) This may help you as well:

Also really need support for running totals based on groups! I despise having to craft workarounds for this kind of thing in Coda. Aren’t we supposed to be living in the AI age where we can apply “magic” to this sort of problem? C’mon Coda, up your formula game!

@Peter_Nelson , Can you show an example of what you are trying to accomplish? Running totals can mean different things in different contexts. If you need column totals of groups, Coda already accommodates for that right out of the box. The example Jannis provided works, but often you only need the…

Running Total formula?

Ask the Community

Piet_Strydom May 1, 2024, 11:27am 6

I came across this good explanation by the big man himself…

Topic		Replies	Views
Running Total (Sum, Average, Median, etc) Ask the Community	10	7216	April 19, 2022
Using SUM function? Ask the Community	20	1809	November 25, 2024
Column with accumulated sum? Ask the Community	4	2198	June 7, 2022
Income - Expenses - Balance calculations Ask the Community	5	1046	December 23, 2021
Sum each column in this row. ie Sum a range of columns Ask the Community	10	2056	July 6, 2023

Running Total formula?

Related topics