# Math or ITE column bug?
**URL:** https://community.glideapps.com/t/math-or-ite-column-bug/71516
**Category:** Ask for Help
**Created:** [March 8, 2024, 9:37am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516 "2024-03-08T09:37:20Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)
#### Post date: [March 8, 2024, 9:37am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/1 "2024-03-08T09:37:20Z")
I’d like to control net weight by using math & ite columns. But, the results on ite colum are not working consistently. Is it because of bug or wrong calculation?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 8, 2024, 9:45am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/2 "2024-03-08T09:45:58Z")
You will probably find that the underlying values may not be exactly what is shown.
Try adjusting the number of decimal places in each of those columns from 2 to 4, and any differences should be immediately apparent.
---
### Author:  [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)
#### Post date: [March 8, 2024, 9:56am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/3 "2024-03-08T09:56:43Z")
Unfortunately, nothing changes…
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 8, 2024, 10:03am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/4 "2024-03-08T10:03:46Z")
Perhaps the differences are smaller than that, but I’m pretty sure that’s what’s causing the discrepancy. If you click into those columns one by one you will see the actual values, which may include many decimal places.
In any case, try the following:
- Change your math column as follows:
```auto
Round(G,2) - Round(T,2)
```
- Then add a second math column using `Round(N,2)`, where `N` is your Nett\_Ton column.
- Then compare the two math columns in your if-then-else column
---
### Author:  [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)
#### Post date: [March 8, 2024, 10:21am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/5 "2024-03-08T10:21:03Z")
Still not any changes… 😔
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 8, 2024, 11:16am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/6 "2024-03-08T11:16:03Z")
Okay, that’s interesting.
There is something that I’m missing here, but I don’t know what it is.
Let’s wait and see what @Jeff_Hager says. He might spot something that I’ve missed.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [March 8, 2024, 1:05pm UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/7 "2024-03-08T13:05:38Z")
I thought the rounding would do the trick. Can subtraction present a floating point issue?
I think the first thing I would try is to change Check\_NettoTon to round the result instead of rounding each number individually.
`Round(G-T, 2)`
If that doesn’t work, I’d probably scrap everything else, go back to one math column, but set it up like this. If the result is zero, then it’s a match.
`Round(Round(N,2) - Round(G-T, 2),2)`
---
### Author:  [@Bungchow\_IDEApps](https://community.glideapps.com/u/Bungchow_IDEApps)
#### Post date: [March 9, 2024, 5:24am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/8 "2024-03-09T05:24:32Z")
The first solution works! Thanks a lot @Darren_Murphy and @Jeff_Hager 🙏
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 16, 2024, 5:25am UTC](https://community.glideapps.com/t/math-or-ite-column-bug/71516/9 "2024-03-16T05:25:17Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.