# Help summing values from multiple data sets

**URL:** <https://forum.inductiveautomation.com/t/help-summing-values-from-multiple-data-sets/2710>\
**Category:** Ignition\
**Created:** [March 2, 2011, 6:21pm UTC](https://forum.inductiveautomation.com/t/help-summing-values-from-multiple-data-sets/2710 "2011-03-02T18:21:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jon.Trusik](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@Jon.Trusik](https://forum.inductiveautomation.com/u/Jon.Trusik)\
**Post date:** [March 2, 2011, 6:21pm UTC](https://forum.inductiveautomation.com/t/help-summing-values-from-multiple-data-sets/2710/1 "2011-03-02T18:21:59Z")

</div>

I have 3 data sets on a window. Each data set is a single column by multiple rows. I’m trying to sum the values from the same row number in each data set to a simple numeric component. ie. I have the following bound expression for the numeric display component. {Root Container.Table 1.data}[0,0]+{Root Container.Table 2.data}[0,0]+{Root Container.Table 3.data}[0,0]. The window will only display the value from the first dataset. ie. it shows {Root Container.Table 1.data}[0,0]. There is data on all rows of all datasets. It always displays the first value in the equation. If I put table 2 first, it displays that value. Can you tell me what’s up?

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [March 2, 2011, 6:58pm UTC](https://forum.inductiveautomation.com/t/help-summing-values-from-multiple-data-sets/2710/2 "2011-03-02T18:58:54Z")

</div>

My guess is that Ignition is trying to concatenate strings together. Try the following:`toFloat({Root Container.Table 1.data}[0,0])+toFloat({Root Container.Table 2.data}[0,0])+toFloat({Root Container.Table 3.data}[0,0])`

---

<div class="post-metadata">

**Author:** ![Jon.Trusik](https://avatars.discourse-cdn.com/v4/letter/j/d78d45/32.png) [@Jon.Trusik](https://forum.inductiveautomation.com/u/Jon.Trusik)\
**Post date:** [March 3, 2011, 10:26am UTC](https://forum.inductiveautomation.com/t/help-summing-values-from-multiple-data-sets/2710/3 "2011-03-03T10:26:14Z")

</div>

Actually tried that yesterday afternoon, but must have fatfingered something, tried it again this morning and works. Thanks!