# Sum error in math column

**URL:** <https://community.glideapps.com/t/sum-error-in-math-column/47997>\
**Category:** Ask for Help\
**Created:** [August 28, 2022, 9:13pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997 "2022-08-28T21:13:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andy\_ET](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_et/32/33891_2.png) [@Andy\_ET](https://community.glideapps.com/u/Andy_ET)\
**Post date:** [August 28, 2022, 9:13pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997/1 "2022-08-28T21:13:37Z")

</div>

![sfhs](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ced2a62600dde393772b367faca73bb468041ff7.png)

Column addition error, I am adding integers so the result should be exact. all columns have precision 1. Solution…???

---

<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:** [August 28, 2022, 9:20pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997/2 "2022-08-28T21:20:09Z")

</div>

Are you using precision or rounding within the formula? Setting precision is only visual. The unrounded value is still stored underneath. I would make sure that you use the Round function in your formula if you want that to be the permanent value.

---

<div class="post-metadata">

**Author:** ![Andy\_ET](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_et/32/33891_2.png) [@Andy\_ET](https://community.glideapps.com/u/Andy_ET)\
**Post date:** [August 28, 2022, 9:26pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997/3 "2022-08-28T21:26:45Z")

</div>

Initial values are integers, then percent calculations are applied, but the result has precision 1.  
From there all the calculations are dispersing from the expected values because it is not using integer values but real values to continue calculating. Is there any way to adjust these results???

---

<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:** [August 28, 2022, 9:38pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997/4 "2022-08-28T21:38:00Z")

</div>

Your math formula should really use the Round function as part of the formula. Precision doesn’t make the value permanent. The underlying values still has decimal numbers, so even though you don’t see the decimal numbers, they are still used as part of your final calcuation.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eba52c943155465f1a211078e5f9ae23620d44f6.png)

---

<div class="post-metadata">

**Author:** ![Andy\_ET](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andy_et/32/33891_2.png) [@Andy\_ET](https://community.glideapps.com/u/Andy_ET)\
**Post date:** [August 28, 2022, 10:08pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997/5 "2022-08-28T22:08:06Z")

</div>

Thanks a lot

---

<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:** [August 29, 2022, 10:08pm UTC](https://community.glideapps.com/t/sum-error-in-math-column/47997/6 "2022-08-29T22:08:42Z")

</div>

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