# Precision "Rounding" Error - triggering condition

**URL:** <https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036>\
**Category:** Report a Bug\
**Created:** [January 31, 2021, 7:35pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036 "2021-01-31T19:35:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [January 31, 2021, 7:35pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036/1 "2021-01-31T19:35:13Z")

</div>

My app’s URL: [https://ketosource.app](https://ketosource.app)

We have a precision rounding on a MATHS field of 1.0.

My understanding this should round to one decimal point.

However, we have values of 1.01 that are failing “less than or equal test” - despite the rounded version being 1.0.

Can you clarify how to effectively round with a Maths field please.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [January 31, 2021, 7:38pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036/2 "2021-01-31T19:38:07Z")

</div>

I’m not sure if the precision in the Number columns affects the actual value. For now, you could change your condition to be less than 1.5 to ensure it captures all that rows that you’re looking for (My assumption would be that something like 1.8 should be treated as 2.0 in your scenario).

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [January 31, 2021, 7:38pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036/3 "2021-01-31T19:38:11Z")

</div>

This is display-only formatting, and does not change cell values.

---

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [January 31, 2021, 7:39pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036/4 "2021-01-31T19:39:11Z")

</div>

@david is there a workaround for rounding in GLIDE?  
(since it’s not a google sheet cell, it’s a glide field)

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [January 31, 2021, 7:41pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036/5 "2021-01-31T19:41:27Z")

</div>

There is actually a ROUND function in the Math column that is possible as a formula. See here: [Math Column - Glide Library](https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column)

PS: a full listing of functions for the Math column would be nice (link it inside the Math column itself as a hint or something).

---

<div class="post-metadata">

**Author:** ![qb15](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/qb15/32/9973_2.png) [@qb15](https://community.glideapps.com/u/qb15)\
**Post date:** [January 31, 2021, 8:48pm UTC](https://community.glideapps.com/t/precision-rounding-error-triggering-condition/22036/6 "2021-01-31T20:48:22Z")

</div>

Awesome - thanks! That fixed it!