# Addition table for product additions

**URL:** <https://forum.inductiveautomation.com/t/addition-table-for-product-additions/27331>\
**Category:** Ignition\
**Created:** [August 10, 2019, 11:57am UTC](https://forum.inductiveautomation.com/t/addition-table-for-product-additions/27331 "2019-08-10T11:57:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![damean.thomas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/damean.thomas/32/11367_2.png) [@damean.thomas](https://forum.inductiveautomation.com/u/damean.thomas)\
**Post date:** [August 10, 2019, 11:57am UTC](https://forum.inductiveautomation.com/t/addition-table-for-product-additions/27331/1 "2019-08-10T11:57:22Z")

</div>

I am trying to determine the best way to create an addition table in ignition. i would like to input a total product weight, then have the operator enter the gross and back weight allowing the table to calculate the net weight and running total then subtract the running total from the desired weight to show remaining. Should i use a data set tag which is cleared on a button push for each product and a table to enter the amounts or should i treat this as a database form entry and run my calculations in a query.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [August 14, 2019, 2:50pm UTC](https://forum.inductiveautomation.com/t/addition-table-for-product-additions/27331/2 "2019-08-14T14:50:16Z")

</div>

I’d like to be able to answer this, but I’m not clear on what your process is to give a good recommendation.

If all of this is manual entry, I’d say to go with a db table for the entire thing. If there is any process monitoring going on, then there would be a mixed bag of things to recommend. 🙂

---

<div class="post-metadata">

**Author:** ![damean.thomas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/damean.thomas/32/11367_2.png) [@damean.thomas](https://forum.inductiveautomation.com/u/damean.thomas)\
**Post date:** [August 14, 2019, 4:19pm UTC](https://forum.inductiveautomation.com/t/addition-table-for-product-additions/27331/3 "2019-08-14T16:19:20Z")

</div>

Thank you for your response, that is what i did this weekend. Everything is working perfectly except the coalesce (sum) that i am trying to attach to a tag for the total and removing an entry from the table and database. but i’m working through it.