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 …

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 speci…

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)*1…

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	1096	March 9, 2022
How to create a cumulative sum of rows in a columns Ask for Help	14	2287	November 24, 2023
Running Totals Ask for Help	3	1162	May 4, 2022
Summarising running data for different periods Ask for Help	3	615	January 5, 2023
Tally the $Total and group Orders by Order_Date Ask for Help	5	703	May 20, 2020

How to calculate Running Total as of a certain date

Related topics