# Lookup Double or Float values

**URL:** <https://forum.inductiveautomation.com/t/lookup-double-or-float-values/26959>\
**Category:** Ignition\
**Created:** [July 29, 2019, 5:21pm UTC](https://forum.inductiveautomation.com/t/lookup-double-or-float-values/26959 "2019-07-29T17:21:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![AGDC04](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/agdc04/32/6366_2.png) [@AGDC04](https://forum.inductiveautomation.com/u/AGDC04)\
**Post date:** [July 29, 2019, 5:21pm UTC](https://forum.inductiveautomation.com/t/lookup-double-or-float-values/26959/1 "2019-07-29T17:21:04Z")

</div>

Hello,  
I have a Expression tag to read a value using a Lookup function.  
In the DB column the values show 0.4 Type Doble. But in the expression tag that read this value, show the integer value link 0. Both field are Double.

I need to change something in tag to work?

See some pic of configuration.

 ![2019-07-29%2014_15_47-JDHMI_BZ%20-%20Ignition-PROD_BZ%20-FINDBZSHPFLR1%20-%20Ignition%20Designer](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e82d02a3eaa6445e993f462f72795b99fa38077b.png)

 ![2019-07-29%2014_16_19-](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e79889e4d6aba832da7a0c7f5d8ac3f3d7b2e2af.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 29, 2019, 5:29pm UTC](https://forum.inductiveautomation.com/t/lookup-double-or-float-values/26959/2 "2019-07-29T17:29:11Z")

</div>

The `lookup` function uses the type of the ‘default’ value to determine what type to coerce all other arguments to. Try changing the literal `0` to `0.0`, or `toDouble(0)` to ensure that the correct type is passed into the function.

---

<div class="post-metadata">

**Author:** ![AGDC04](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/agdc04/32/6366_2.png) [@AGDC04](https://forum.inductiveautomation.com/u/AGDC04)\
**Post date:** [July 29, 2019, 8:03pm UTC](https://forum.inductiveautomation.com/t/lookup-double-or-float-values/26959/3 "2019-07-29T20:03:46Z")

</div>

Thanks, works great now. Thanks for advice.