# \[IGN-2200\]Replace values displayed as "null" in the perspective table

**URL:** <https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161>\
**Category:** Ignition\
**Tags:** ignition80, perspective\
**Created:** [April 1, 2021, 9:27am UTC](https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161 "2021-04-01T09:27:28Z")\
**Posts on this page:** 1\
**Showing post:** 19

<div class="post-metadata">

**Author:** ![witman](https://avatars.discourse-cdn.com/v4/letter/w/d2c977/32.png) [@witman](https://forum.inductiveautomation.com/u/witman)\
**Post date:** [January 10, 2023, 6:12pm UTC](https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161/19 "2023-01-10T18:12:34Z")

</div>

Thanks! Will update address this buggy behavior, or something else?

> [@\[BUG\] Perspective Table number format breaks if first row has null value](https://forum.inductiveautomation.com/t/bug-perspective-table-number-format-breaks-if-first-row-has-null-value/44897):
>
> This is in Ignition 8.1.2–I don’t have a later version installed yet to confirm whether it applies to them as well. All of these columns have the same format settings: [image] The null values in October and November render as blank (great) and the number format is applied with one decimal place as expected. In the December column, the first row has a null value and it renders as null (as well as later nulls in this column) and the number formatting doesn’t get applied to any values in the col…

---

_[View the full topic](https://forum.inductiveautomation.com/t/ign-2200-replace-values-displayed-as-null-in-the-perspective-table/45161)._