# Numeric Precision ignored

**URL:** <https://community.glideapps.com/t/numeric-precision-ignored/34521>\
**Category:** Ask for Help\
**Created:** [November 15, 2021, 6:14am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521 "2021-11-15T06:14:29Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 15, 2021, 6:14am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/1 "2021-11-15T06:14:29Z")

</div>

Hi guys,  
I have a number column with precision 1 that I Sum and then write to another table to a text column using an action, and ignores the units (that is a known issue with Rollup).  
The written value is with the full possible precision.  
am I missing something here? bug? any workarounds?  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b59675c361c49bc2df907db420d7a5f1dbf0a41.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/1/31309a3349d5efe64e74fc0cd1b3cb9a16088185.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/333a0143f99b436cc83cba3590eb9a3901cd8f8c.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 15, 2021, 6:17am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/2 "2021-11-15T06:17:57Z")

</div>

Regardless of the Precision set on a number column, the underlying unrounded value is always stored. If you intend to used the value for other math, you should use a math column with a Round function to give it a true rounded value. Setting Precision and Units is only for display purposes.

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 15, 2021, 6:20am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/3 "2021-11-15T06:20:31Z")

</div>

I tried that too,  
still get the full number

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/6974dd07e3fa4453fab31422c68a8a7641dcab7d.png)

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 15, 2021, 6:23am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/4 "2021-11-15T06:23:20Z")

</div>

Its supposed to show the sum of calories consumed a day,  
and I got feedback from my users that were really amazed of the accuracy 😆

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f0f3b8f7fc84545cfd8b6add43d49f6a2df7f31a.jpeg)

---

<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:** [November 15, 2021, 6:27am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/5 "2021-11-15T06:27:46Z")

</div>

Create a math column in whichever table your calorie counts are stored, something like `Round(Calories,0)`, and then do your rollup on that column.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 15, 2021, 6:31am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/6 "2021-11-15T06:31:17Z")

</div>

Round will only work for whole numbers in the math column, I believe. You can’t specify decimal places. If you need to factor in 2 decimal places, for example, you need to multiply by 100, round, then divide by 100.

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 15, 2021, 6:32am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/7 "2021-11-15T06:32:07Z")

</div>

> [@Darren\_Murphy](#):
>
> Round(Calories,0)

Whole numbers will work for me in this case.  
I will try

---

<div class="post-metadata">

**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\
**Post date:** [November 15, 2021, 6:34am UTC](https://community.glideapps.com/t/numeric-precision-ignored/34521/8 "2021-11-15T06:34:49Z")

</div>

Yep, rounding before summing worked.  
Thank you!