- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 19, 2022 08:32 AM
Hello alls,
I have a sum up column as shown in the picture above. Actually, I use excell for the calculation (I copy the value column in excell, I make the calculation of the sumup column in excell and then I copy back to the airtable sumup column). Hence, I'd like to know if it exist any function or script that could do this calculation directly in airtable. Thx
Solved! Go to Solution.
Accepted Solutions
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 19, 2022 05:50 PM
It looks like what you want is a "running total". The technique created by W_Vann_Hall in the link by Sara is a very old way of doing things. That technique was designed before Scripting existed, and it requires some very complex formulas and rollups that can be very slow and resource intensive. Now that scripting exists, you are usually better off using scripting to calculate a running total. There is an example script for creating a running total in the scripting documentation.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 19, 2022 10:31 AM
Hi, have you checked this post? it has a lot of tutorials
![kuovonne kuovonne](https://community.airtable.com/legacyfs/online/avatars/3X/b/c/bcecb2d58f8302e9d9f520621c02ff41be54488c.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 19, 2022 05:50 PM
It looks like what you want is a "running total". The technique created by W_Vann_Hall in the link by Sara is a very old way of doing things. That technique was designed before Scripting existed, and it requires some very complex formulas and rollups that can be very slow and resource intensive. Now that scripting exists, you are usually better off using scripting to calculate a running total. There is an example script for creating a running total in the scripting documentation.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 20, 2022 09:06 AM
Thank you Sara, I cheked the post but unfortunately it's a little confusing for a newbie like I am.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 20, 2022 09:08 AM
Don't worry! the important is that you solved the problem 😊 Thank you, Kuovonne!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 20, 2022 09:08 AM
Thank you Kuovonne, it is precisely what I need. There's a little delay in the calculation but It works fine.
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)