# Cumulative Sum or Running Total

**URL:** <https://forums.knack.com/t/cumulative-sum-or-running-total/9245>\
**Category:** Ask Developers\
**Created:** [December 2, 2018, 3:31pm UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245 "2018-12-02T15:31:50Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![SeanJeffry31227](https://avatars.discourse-cdn.com/v4/letter/s/7c8e57/32.png) [@SeanJeffry31227](https://forums.knack.com/u/SeanJeffry31227)\
**Post date:** [December 2, 2018, 3:31pm UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/1 "2018-12-02T15:31:50Z")

</div>

Hello, I've run into a road block and it seems other users have had very similar problems. The short story is that I need to be able to sum the amounts from all chronologically past records in an Object from the same Object and display that sum in the current row. In Excel this would be a SUMIF() or a combination of other functions. With Knack, I can't access all other rows on the same table to create the cumulative sum. Creating a running total of billing and hours is a high demand feature.

---

<div class="post-metadata">

**Author:** ![knckusr](https://avatars.discourse-cdn.com/v4/letter/k/e95f7d/32.png) [@knckusr](https://forums.knack.com/u/knckusr)\
**Post date:** [May 23, 2021, 6:49pm UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/2 "2021-05-23T18:49:57Z")

</div>

Same issue:

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [December 6, 2018, 4:55am UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/3 "2018-12-06T04:55:14Z")

</div>

Hello Sean,

&nbsp;

Look like this is only possible using javascript functionality.

&nbsp;

For example when we try to create a records then we already Get Sum of previous records and save it in hidden field (or hide textbox)

&nbsp;

After we Sum Enterd Value and Sum of previous Value in another field to show .

&nbsp;

Regards,

Sunny Singla

[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)

+919855089359

---

<div class="post-metadata">

**Author:** ![ASOKAN](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@ASOKAN](https://forums.knack.com/u/ASOKAN)\
**Post date:** [October 10, 2021, 11:17am UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/4 "2021-10-10T11:17:50Z")

</div>

Hi Sunny,  
If you have one Can you please share the javascript to get this cumulative running total on the same object with filter(condition) option.  
Regards  
Asokan

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [October 10, 2021, 1:54pm UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/5 "2021-10-10T13:54:20Z")

</div>

Hello Asokan,

Sorry currently have no javascript code available for this. But will create if you want with filters as well.

Regards,  
Sunny Singla  
[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)  
+919855089359

---

<div class="post-metadata">

**Author:** ![ASOKAN](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@ASOKAN](https://forums.knack.com/u/ASOKAN)\
**Post date:** [November 19, 2021, 9:12am UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/6 "2021-11-19T09:12:48Z")

</div>

Hi Sunny,  
If your time allows I appreciate this JAVASCRIPT.

Regards  
Asokan

---

<div class="post-metadata">

**Author:** ![Sunny\_Singla](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/sunny_singla/32/1007_2.png) [@Sunny\_Singla](https://forums.knack.com/u/Sunny_Singla)\
**Post date:** [November 19, 2021, 9:28am UTC](https://forums.knack.com/t/cumulative-sum-or-running-total/9245/7 "2021-11-19T09:28:05Z")

</div>

Hello Asokan,

You can mail me detail please with access to the application and object name.

Regards,  
Sunny Singla  
[ssingla1985@gmail.com](mailto:ssingla1985@gmail.com)  
+919855089359
