# \[BUG\] Perspective Table number format breaks if first row has null value

**URL:** <https://forum.inductiveautomation.com/t/bug-perspective-table-number-format-breaks-if-first-row-has-null-value/44897>\
**Category:** Ignition\
**Tags:** perspective, ignition80\
**Created:** [March 25, 2021, 8:41am UTC](https://forum.inductiveautomation.com/t/bug-perspective-table-number-format-breaks-if-first-row-has-null-value/44897 "2021-03-25T08:41:22Z")\
**Posts on this page:** 1\
**Showing post:** 9

<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:** [March 29, 2021, 4:40pm UTC](https://forum.inductiveautomation.com/t/bug-perspective-table-number-format-breaks-if-first-row-has-null-value/44897/9 "2021-03-29T16:40:30Z")

</div>

Hopefully the underlying Perspective Table implementation will handle this in the future for columns with specified types. For now, this script transform does the trick:

```auto
	from java.lang import Float
	from com.inductiveautomation.ignition.common.util import DatasetBuilder
	
	if value is None:
		return value
	else:
		# Build new dataset with specified column types.
		colNames = ["Month 1", "Month 2", "Month 3"]
		colTypes = [Float, Float, Float]
		b = DatasetBuilder.newBuilder().colNames(colNames).colTypes(colTypes)
		# Copy original data into new dataset.
		for row in system.dataset.toPyDataSet(value):
			b.addRow(row[x] for x in range(len(row)))
		return b.build()

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/bug-perspective-table-number-format-breaks-if-first-row-has-null-value/44897)._