[Urgent] how to net a value with a list of value?

[Siddharth Rout]

You can use SQL query to get the sum from the table

SELECT SUM(expression) FROM TABLENAME

Where expression is the Unit Field (Which I hope you have set it as numeric) and TABLENAME is the name of the table.

When you get that simply sum it up as I mentioned above and then use SQL Insert to add the new record...