Does anyone know how to do a running total? In Excel it would be easy: Prior Result + new Result = Running Total thus far But I can’t figure it out in Coda. [image] I need this so that I can calculate the payback period on a customer. E.g. A customer costs $3,000 to acquire and they are paying …

I’ve noticed that when searching for the term “Running Total” on the community, this post shows up as the first suggestion, but it is an unresolved post. Therefore, I am posting the reference to a related post here, that has indeed been resolved and outlines the solution on how to set up a running …

Hey @cnr , this is kind of tricky in Coda right now but there is a working solution. I’ve described it here [image] Adding values from previous rows Hi. I have this table that I want to use as a money tracker slight_smile The goal is to list transactions updating the …

Hi @Daniel_Stieber I’ve been having a similar issue with a need for a running total calculation. Does anyone know if this is a feature/formula that is going to be introduced?

Hey Michael, can you provide some more information what do you want to achieve? You can use sum() to create a total of a list/column. If you want to just show the total at the end of the table, you can use the the native footer bar of the table. If you want an ongoing total in each row, you can use…

Okay - so I’m almost there - CORECTION - it worked! Requirements: you have your table sorted you’re adding new row at the top or in the middle of the table you need a running balance the running balance column needs to sum from bottom to top Current Solution: using rank - create a Visual Posit…

Thanks @shishir ! Out of curiosity - Is there a way to combine the PreviousRow formula and the CumulativeTotal formula into one to avoid having an extra column, PreviousRow? I’d like to try an apply that methodology to this section and other areas of my document if so.

@Justin_VanDervort how are you getting your raw bank feeds into Coda? Manually or? I know one can pay ($5/month) for Tiller to scrape your bank feeds into Google Sheets, and then create a one way sync from that Google Sheet to a Coda doc using Google App Script (thx @Al_Chen_Coda ). But I’m wonderi…

This needs to be way easier. I suspect such functionality in my 3000 row accounting document is what is causing it to slow to a crawl. I’ve ended up deleting the running total columns. My only use case is to show it in a line a graph. So ideally, rather than adding a running total column to the ta…

I think there’s a way to do this more efficiently by using an index-lookup approach rather than a find approach. Make a column called Order that converts your datetime objects into a unique integer. Then Running Total formula can just be thisRow.Value + thisTable.Sort(true, Order).Nth(thisRow.Order…

Running Total (Sum, Average, Median, etc)

Ask the Community

shishir May 26, 2019, 3:41pm 6

This may help you as well:

Column with accumulated sum?

Bank Account Balance Sheet

How do I auto fill a select box?

Running Total formula?

Topic		Replies	Views
Running Total formula? Ask the Community	7	697	May 7, 2024
Column with accumulated sum? Ask the Community	4	2198	June 7, 2022
How do i end my row with sum off all previous columns? Ask the Community	17	4466	March 2, 2022
Income - Expenses - Balance calculations Ask the Community	5	1046	December 23, 2021
Adding values from previous rows Ask the Community	14	9930	January 17, 2023

Running Total (Sum, Average, Median, etc)

Related topics