## TL:DR

In any math column, use `0 - 0 + ...`

to force empty values to be zeros! Huge thanks to @ThinhDinh for leading me to this solution!

In any math column, use `0 - 0 + ...`

to force empty values to be zeros! Huge thanks to @ThinhDinh for leading me to this solution!

11 Likes

Honestly I still don’t know how this works

1 Like

Funny!

By chance I had the same problem on Monday but I fixed it in this way:

Feliz día!

3 Likes

So…any sort of `0`

math seems to work!

`0 - 0 + ...`

`-0 + 0 + ...`

`0 / 1 + ...`

`0 * 0 + ...`

`0 ^ 1 + ...`

`log(1) + ...`

4 Likes

Right but the Sum cases don’t work if they are at the end of operation. I mean:

if X=empty:

```
a) 0-0 +X => 0
b) X+ 0-0 => empty
```

The others work perfectly no matter where you put them.

Saludos!

This is … eerie?! Is Mark aware of this? It’s like there is a ghost in his code.

I’m not sure at all, but it could be that the ‘0’ symbol represents both “zero” and the “empty set” in the language that’s used in Glide’s backend (Typescript?).

If there is the case, then inserting any math operation whose output is 0 and then adding the empty cell will return the number “0” instead of simply returning the empty set “0” without the math. So 2-2+… would also work I think.

What I don’t understand is why 0+0 or 0-0 at the end of the math would be considered the empty set, but not at the beginning. Coders would probably now. Maybe it’s just the grammar of the language?

3 Likes

This pink text on grey background is somewhat hard to read. Is this new? Could someone adjust this?

2 Likes

Oh weird. I see that too…on my phone it looks different.