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…
-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…
How did you generate the SOLDE column? Did you just input it manually? Is it a column in Google Sheets?
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)…
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.
1 Like
That was my first suspicion, but Glide definitely sees it as a number with 2 decimals…
