# Charts rounding/floating point display problems

**URL:** <https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007>\
**Category:** Report a Bug\
**Created:** [January 27, 2020, 10:55am UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007 "2020-01-27T10:55:34Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![chrishoward](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chrishoward/32/2545_2.png) [@chrishoward](https://community.glideapps.com/u/chrishoward)\
**Post date:** [January 27, 2020, 10:55am UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/1 "2020-01-27T10:55:34Z")

</div>

Anyone else get problems with pie and donut charts and rounding/floating point displaying wrong in the chart but fine in the legend??

The data source does have round(value,2) applied. And it’s formatted to 2 decimal places as well.

 ![CleanShot 2020-01-27 at 21.51.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/58e662518885f7f0e9ab02f919fd23acfca6d21f.png)

This is not unique to this particular app. I have encountered it numerous times before.

---

<div class="post-metadata">

**Author:** ![dmilleravid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dmilleravid/32/2230_2.png) [@dmilleravid](https://community.glideapps.com/u/dmilleravid)\
**Post date:** [January 27, 2020, 1:16pm UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/2 "2020-01-27T13:16:29Z")

</div>

I get that quite often, too. I also tried using ROUND() to no avail. Kind of annoying,

---

<div class="post-metadata">

**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\
**Post date:** [January 27, 2020, 2:23pm UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/3 "2020-01-27T14:23:30Z")

</div>

We’ll fix that soon.

---

<div class="post-metadata">

**Author:** ![Noel\_25](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/noel_25/32/2028_2.png) [@Noel\_25](https://community.glideapps.com/u/Noel_25)\
**Post date:** [February 26, 2020, 5:04pm UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/4 "2020-02-26T17:04:32Z")

</div>

What im currently doing with my data is to add another helper column to convert the value into absolute number and use that column as the quantity

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [June 16, 2020, 7:34am UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/5 "2020-06-16T07:34:54Z")

</div>

We need the Round feature to be available in the app it self

---

<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:** [June 17, 2020, 11:51pm UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/6 "2020-06-17T23:51:21Z")

</div>

You should be able to set precision on a numeric column. Or are you trying to do it within a math formula? I have found in the past that you can set precision on numeric columns, but the rounded value isn’t respected in the math and instead uses the underlying value. I’ve gotten around this creating a template column of the rounded numeric column, and used the template in the math formula.

---

<div class="post-metadata">

**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\
**Post date:** [June 20, 2020, 4:19am UTC](https://community.glideapps.com/t/charts-rounding-floating-point-display-problems/4007/7 "2020-06-20T04:19:40Z")

</div>

@Jeff_Hager worked perfectly thanks
