Hi there, I saw this post and wondered if there was a way to create a similar result, but based on the dates. Meaning, I have a table of transaction entries with dates and amounts. I would like to see a running total for the specific date in the row that takes into consideration all amounts from older dates (basically your current account balance).

Seems like you forgot to link to the post you saw. Anyway, I think you can use a query column to query all rows that belong to this row’s user and have a timestamp that is either equal to this row’s timestamp or before. Then use a rollup to sum the amounts.

Oops! [image] Running Totals Ask for Help Hi Glide Community, Is there a way of calculating running totals in the Glide data editor? I am trying to replicate the below that can be done in Google Sheets but seems to be very difficult in Glide as roll ups are column specific, unless using a relation/lookup/specific array setups. [Screen Shot 2022-05-03 at 7.02.23 PM] [Screen Shot 2022-05-03 at 7.02.37 PM] Is there a way of doing a running total like this? I have tried a different ways with arrays and using the row index but still no …

Please let us know if you find any further challenge on implementing it.

So the challenge with the TimeStamp is that the transaction entries will include a Transaction date already (the transactions will be bulk loaded and then trend analysis will be done). I thought about converting the date to an integer using the formula I found here… Year(Date)*10^4 +Month(Date)*10^2 +Day(Date) But got stuck trying to sum the transactions for a specific day AS WELL AS all previous dates (but non of the future dates). The idea would be as follows… Date : Amount : Balance as of this date 3/1/22 : $10 : $10 3/3/22 : $13 : $23 3/4/22 : -$5 : $18 3/6/22 : $100 : $118 3/7/22 : -$25 : $93 3/9/22 : $55 : $148

How to calculate Running Total as of a certain date

Ask for Help

Technoladie November 27, 2023, 11:31pm 3

Oops!

Topic		Replies	Views
SUM of column data for each day Ask for Help	10	1179	March 9, 2022
How to create a cumulative sum of rows in a columns Ask for Help	14	2378	November 24, 2023
Running Totals Ask for Help	3	1199	May 4, 2022
Summarising running data for different periods Ask for Help	3	640	January 5, 2023
Tally the $Total and group Orders by Order_Date Ask for Help	5	734	May 20, 2020

How to calculate Running Total as of a certain date

Related topics