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?

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)	10	7189	April 19, 2022
Using SUM function?	20	1786	November 25, 2024
Column with accumulated sum?	4	2181	June 7, 2022
Income - Expenses - Balance calculations	5	1041	December 23, 2021
Sum each column in this row. ie Sum a range of columns	10	2023	July 6, 2023

Running Total formula?

Related topics