# Floating Point format not working in Template

**URL:** <https://forum.inductiveautomation.com/t/floating-point-format-not-working-in-template/10346>\
**Category:** Ignition\
**Created:** [August 14, 2015, 4:30pm UTC](https://forum.inductiveautomation.com/t/floating-point-format-not-working-in-template/10346 "2015-08-14T16:30:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![qversa](https://avatars.discourse-cdn.com/v4/letter/q/35a633/32.png) [@qversa](https://forum.inductiveautomation.com/u/qversa)\
**Post date:** [August 14, 2015, 4:30pm UTC](https://forum.inductiveautomation.com/t/floating-point-format-not-working-in-template/10346/1 "2015-08-14T16:30:29Z")

</div>

Hi, I have a Template with a Custom Property called ScaledEU of Type String. The Number Format Pattern is #,##0.#. When I use the Template I am not getting the decimal. Example: 14.32 shows as 14, should show as 14.2. If I simply use a Numeric Label with the same format and bind it to the same SQL tag I’m using in the Template binding it displays correctly. What could be the issue?

---

<div class="post-metadata">

**Author:** ![qversa](https://avatars.discourse-cdn.com/v4/letter/q/35a633/32.png) [@qversa](https://forum.inductiveautomation.com/u/qversa)\
**Post date:** [August 14, 2015, 7:51pm UTC](https://forum.inductiveautomation.com/t/floating-point-format-not-working-in-template/10346/2 "2015-08-14T19:51:47Z")

</div>

Correction: My Custom Property called ScaledEU is of Type Float, NOT String.

---

<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:** [August 14, 2015, 7:56pm UTC](https://forum.inductiveautomation.com/t/floating-point-format-not-working-in-template/10346/3 "2015-08-14T19:56:59Z")

</div>

That sounds like there’s a conversion to integer in some property along the way. Is there a reason you must use a string property?

---

<div class="post-metadata">

**Author:** ![qversa](https://avatars.discourse-cdn.com/v4/letter/q/35a633/32.png) [@qversa](https://forum.inductiveautomation.com/u/qversa)\
**Post date:** [August 28, 2015, 12:41am UTC](https://forum.inductiveautomation.com/t/floating-point-format-not-working-in-template/10346/4 "2015-08-28T00:41:33Z")

</div>

I posted a correction, it was a Float, not a String. I’m using Float all the way thru. Double checked everything. Using a A-B ControlLogix which is 32-bit so using Float instead of Double. Just getting unexpected results. Even set the SQL tags Format in Meta Data to #,##0.#.
