# Disappearing decimals with an If, then, else column

**URL:** <https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930>\
**Category:** Ask for Help\
**Created:** [October 12, 2023, 2:22pm UTC](https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930 "2023-10-12T14:22:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [October 12, 2023, 2:22pm UTC](https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930/1 "2023-10-12T14:22:27Z")

</div>

I am facing the following issue: In a Glide table, I have two decimal columns; for example, in the first column, there’s a value of €100.00, and in the second column, a value of €200.00. Through an If, Then, Else column, I want to select a value (in this case, “if column 1 has a value, then column 2”) but in my If, Then, Else column, I get the value “200” instead of €200.00.

In other words, the currency symbol and the decimal values after the comma are not displayed. I have many such columns, so a solution using a “template column” isn’t elegant.

Is there another solution?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 12, 2023, 2:26pm UTC](https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930/2 "2023-10-12T14:26:50Z")

</div>

yeah, this is a known issue.

The workaround is to add a math column after the if-then-else to reapply the display precision and units.

---

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [October 12, 2023, 2:44pm UTC](https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930/3 "2023-10-12T14:44:31Z")

</div>

Thanks Darren,

I can add a math column but can’t add a formule from a if, then, else column. That doesn’t work. Because it’s introduce a cycle of dependencies.

---

<div class="post-metadata">

**Author:** ![Ronald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ronald/32/49776_2.png) [@Ronald](https://community.glideapps.com/u/Ronald)\
**Post date:** [October 12, 2023, 2:51pm UTC](https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930/4 "2023-10-12T14:51:07Z")

</div>

Sorry, i did’t pay attention enough.  
That solution works!

Thank you Darren!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 19, 2023, 2:52pm UTC](https://community.glideapps.com/t/disappearing-decimals-with-an-if-then-else-column/66930/5 "2023-10-19T14:52:00Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.