# System.dataset.addColumn adds decimals to float values in added column

**URL:** <https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948>\
**Category:** Ignition\
**Tags:** ignition81, scripting\
**Created:** [June 20, 2022, 11:43am UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948 "2022-06-20T11:43:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![daniele1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/daniele1/32/31531_2.png) [@daniele1](https://forum.inductiveautomation.com/u/daniele1)\
**Post date:** [June 20, 2022, 11:43am UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/1 "2022-06-20T11:43:18Z")

</div>

When I add a column to a dataset using the System.dataset.addColumn the values of the added column comes out with a lot of decimals even if I round them up before adding them to the python list.  
This is the output excel, the last column is the one I added.  
 ![immagine](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/e/9e36c6a432905962bdc7269053d213004da4e5bf.png)  
Any way to fix this?

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [June 20, 2022, 11:48am UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/2 "2022-06-20T11:48:39Z")

</div>

dont use type float

---

<div class="post-metadata">

**Author:** ![daniele1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/daniele1/32/31531_2.png) [@daniele1](https://forum.inductiveautomation.com/u/daniele1)\
**Post date:** [June 20, 2022, 11:49am UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/3 "2022-06-20T11:49:32Z")

</div>

double is not accepted int the function argument for some reason

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [June 20, 2022, 11:50am UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/4 "2022-06-20T11:50:44Z")

</div>

> [@daniele1](#):
>
> for some reason

seems like you should find the reason then xd  
got some code i can look at?

---

<div class="post-metadata">

**Author:** ![daniele1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/daniele1/32/31531_2.png) [@daniele1](https://forum.inductiveautomation.com/u/daniele1)\
**Post date:** [June 20, 2022, 11:59am UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/5 "2022-06-20T11:59:46Z")

</div>

XD  
Here’s the code

```auto
dataset_query=system.dataset.toDataSet(sql_query)

paths_1=["[default]METEO/CARAVAGGIO/LivelloPioggia"]

col_caravaggio = []

date_from_mil=system.date.toMillis(date_from)
date_to_mil=system.date.toMillis(date_to)
time_frame=288 //1 day=12*24
time_frame_mil=time_frame*5*60*1000
	
for startDate_mil in range(date_from_mil,date_to_mil,time_frame_mil):	
	endDate_mil=startDate_mil+time_frame_mil-1000; 
	
	startDate=system.date.fromMillis(startDate_mil)
	endDate=system.date.fromMillis(endDate_mil)
	
	data_1 = system.tag.queryTagHistory(paths_1,startDate, endDate,1,"Average")
	
	caravaggio = round(data_1.getValueAt(0,1),2)

	col_caravaggio.append(caravaggio)
	
dataset_final=system.dataset.addColumn(dataset_query, col_caravaggio,"Caravaggio",float)

excel = system.dataset.toExcel(True, [dataset_final])
	

```

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [June 20, 2022, 12:52pm UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/6 "2022-06-20T12:52:03Z")

</div>

alright seems python doesnt have a double, but java has.

`import java.lang.Double`  
and use it instead of float  
`dataset_final=system.dataset.addColumn(dataset_query, col_caravaggio,"Caravaggio",java.lang.Double)`  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5b69f549e8d94021f7481809be52d127e9dd1f4f.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 20, 2022, 4:20pm UTC](https://forum.inductiveautomation.com/t/system-dataset-addcolumn-adds-decimals-to-float-values-in-added-column/60948/7 "2022-06-20T16:20:04Z")

</div>

> [@victordcq](#):
>
> alright seems python doesnt have a double

That's because jython's floats _ **are** _ double (always). The issue is that datasets are java, not jython, and need java column types.