# ABS() function bug? **URL:** \ **Category:** Ask for Help\ **Created:** [January 11, 2022, 9:30pm UTC](https://community.glideapps.com/t/abs-function-bug/37051 "2022-01-11T21:30:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [January 11, 2022, 9:30pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/1 "2022-01-11T21:30:13Z")
I have numeric column with zeros and négative number, I created a math column that takes ABS(numeric column). The result is puzzling as zeros become -0 and negative numbers result in NIL… ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/eeb9633a38be5877a641faacb6b96adac9833307.png) ---
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [January 11, 2022, 9:36pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/2 "2022-01-11T21:36:05Z")
-SOLDE also gives the same erroneous result. -1\*SOLDE works but zeros become -0.00, I guess I can live with that, but still there seems to be some bug… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [January 11, 2022, 11:59pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/3 "2022-01-11T23:59:13Z")
How did you generate the SOLDE column? Did you just input it manually? Is it a column in Google Sheets? ---
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [January 12, 2022, 1:33pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/4 "2022-01-12T13:33:12Z")
That seemed like an innocuous question but it got me thinking… It’s a Google Sheets column, and although it was numeric it had some formatting that clearly threw glide : #,##0.00\_);[Red]-#,##0.00\_);"" Once i changed it to a simple number formatting in Sheets, it works. Still somewhat a bug I think as -1\*SOLDE works even with the fancy formatting, but not -SOLDE or abs(SOLDE)… ---
**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:** [January 12, 2022, 1:40pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/5 "2022-01-12T13:40:50Z")
The values shown in your Solde column make me a little suspicious that Glide may not be correctly recognising it as a number type. I realise that the `123` next to the column name indicates that it does, but that can sometimes be misleading. Try this: - Edit the column in the Glide Data editor, and check the column type. - If my suspicion is correct, you might find that it is set as “None” - If that is the case, change it to Number That might resolve the issue. ---
**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\ **Post date:** [January 12, 2022, 2:29pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/6 "2022-01-12T14:29:32Z")
That was my first suspicion, but Glide definitely sees it as a number with 2 decimals… ---
**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:** [January 12, 2022, 3:01pm UTC](https://community.glideapps.com/t/abs-function-bug/37051/7 "2022-01-12T15:01:05Z")
hmm, if that’s the case, I still wonder about these… ![Screen Shot 2022-01-12 at 10.59.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/8/182c185604c577a7853b8ee8b5a07988b6bf8712.png)