# Table Calculations to Text Box

**URL:** <https://forum.inductiveautomation.com/t/table-calculations-to-text-box/3271>\
**Category:** General Discussion\
**Created:** [September 9, 2011, 7:18pm UTC](https://forum.inductiveautomation.com/t/table-calculations-to-text-box/3271 "2011-09-09T19:18:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sdarling](https://avatars.discourse-cdn.com/v4/letter/s/2acd7d/32.png) [@sdarling](https://forum.inductiveautomation.com/u/sdarling)\
**Post date:** [September 9, 2011, 7:18pm UTC](https://forum.inductiveautomation.com/t/table-calculations-to-text-box/3271/1 "2011-09-09T19:18:18Z")

</div>

What is the best way to do complex database table calculations and then display the result onto the display? I started by having a dynamic property in the window to store the value but I need to do an expression from multiple database queries. It seems like ignition doesn’t allow the combining of the two am I missing something obvious?

---

<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:** [September 9, 2011, 8:12pm UTC](https://forum.inductiveautomation.com/t/table-calculations-to-text-box/3271/2 "2011-09-09T20:12:38Z")

</div>

In this case you need to write a script that creates a new dataset from the calculated values. Take a look at the system.dataset.toDataSet function here:

[inductiveautomation.com/supp … ataset.htm](http://www.inductiveautomation.com/support/usermanuals/ignition/system_dataset_todataset.htm)

Hopefully that will help you get started.