# How to calculate Running Total as of a certain date

**URL:** https://community.glideapps.com/t/how-to-calculate-running-total-as-of-a-certain-date/68154
**Category:** Ask for Help
**Created:** [November 27, 2023, 1:42am UTC](https://community.glideapps.com/t/how-to-calculate-running-total-as-of-a-certain-date/68154 "2023-11-27T01:42:03Z")
**Posts on this page:** 1
**Showing post:** 5

<div class="post-metadata">

### Author: ![Technoladie](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/technoladie/32/52202_2.png) [@Technoladie](https://community.glideapps.com/u/Technoladie)
#### Post date: [November 27, 2023, 11:45pm UTC](https://community.glideapps.com/t/how-to-calculate-running-total-as-of-a-certain-date/68154/5 "2023-11-27T23:45:51Z")

</div>

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](https://community.glideapps.com/t/how-to-sum-values-based-on-date-daily-weekly-monthly/66313/2)…  
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

---

_[View the full topic](https://community.glideapps.com/t/how-to-calculate-running-total-as-of-a-certain-date/68154)._