# The table shows 0 instead of empty **URL:** \ **Category:** Ignition\ **Tags:** perspective, ignition80\ **Created:** [April 9, 2023, 3:03am UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222 "2023-04-09T03:03:17Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![471421143](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/471421143/32/38211_2.png) [@471421143](https://forum.inductiveautomation.com/u/471421143)\ **Post date:** [April 9, 2023, 3:03am UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222/1 "2023-04-09T03:03:17Z")
![3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/e/8ea2f38b9bfcf471c494ee465373348ea1a6439e.png) Tag value is null, tag type is Float, But in Table show value is 0. I want show null or empty. How to do that? Pease help me, Thanks a lot! ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [April 9, 2023, 12:13pm UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222/2 "2023-04-09T12:13:14Z")
Is the table using a history binding? If so, please show the binding. ---
**Author:** ![471421143](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/471421143/32/38211_2.png) [@471421143](https://forum.inductiveautomation.com/u/471421143)\ **Post date:** [April 10, 2023, 10:31am UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222/3 "2023-04-10T10:31:18Z")
![binding](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/b/1b2857d8f222ef4959f5dd3a4db7d2f036b9acf6.png) ![database](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/0/0050775dcdacf3e4707bd943dc59a8993627af5f.png) ![table](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/1/01627abe16e80780ca058e7d84d4223f54022ea9.png) Please see the screenshot below. I see null stored in the database, but the temperature displayed in the table is 0. I am not sure whether it has anything to do with the binding configuration ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [April 10, 2023, 10:57am UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222/4 "2023-04-10T10:57:32Z")
I don't know enough to answer for sure but a simple check would be to change the binding Value Format from _Dataset_ to _Document_. You can then inspect the returned values in the PROPS.data of the table component. If you see `null`s in there then the table component is converting them to '0'. If not then the problem is probably with the history interpolation (which I have found to be almost useless). A quick test with the default table data shows that entering 'null' in the population column results in an empty cell in auto or numeric rendering. Rendering as a string shows 'null'. ---
**Author:** ![471421143](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/471421143/32/38211_2.png) [@471421143](https://forum.inductiveautomation.com/u/471421143)\ **Post date:** [April 11, 2023, 1:21pm UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222/5 "2023-04-11T13:21:56Z")
![2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/1/f156917adf977a64a18fc6a20e0dd00ec9b37607.png) ![3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/b/ab9f6659cee6adb3c0191eae21add9c3398c93f6.png) I manually deleted the 0 value in Dataset Editer, and the Table showed nothing. As shown in Figure 2. I tried to script change the 0 value in the DataSet Editor to null. However, 0 is still displayed in the Table after running, as shown in Figure 3. Very helpless. ---
**Author:** ![471421143](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/471421143/32/38211_2.png) [@471421143](https://forum.inductiveautomation.com/u/471421143)\ **Post date:** [April 14, 2023, 2:12am UTC](https://forum.inductiveautomation.com/t/the-table-shows-0-instead-of-empty/72222/6 "2023-04-14T02:12:45Z")
I have solved my problem with the help of the engineer. I post the method for the reference of friends who need it. ![no-1](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/c/2c83265efd04d45e84165881c0d42d105394ab7e.png) ![no-2](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/d/7da28c5766de1da5cb470cfdb1a1484b19ff0ce8.png) ![no-3](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/8/985785aba4f035533777b2cf97bd5dc1bf5f677d.png)