Sum list from local DB


I’m looking for an option to get a number sum from a list located in the local DB Data sources.
I managed to go around and create the desired sum number, but the problem is when I’m deleting a row from the data viewer the number goes crazy of course because the deleted item wasn’t deleted from the list properly.

In short, is there a smart way to create a sum number from a column in the local data sources DB and when an item is deleted, update the sum number correctly?

Thanks in advance!

Hey @oreeldadln

There are a few examples of how to do this in the Community that you can find by searching for “Sum List

Here’s one that jumped out at me:

let me know whether or not that works for you.

Working Perfectly. Thank you!