Math Error 1 x 1 doesn't equal 1?

[Robert_Petitto]

My app’s URL: https://go.glideapps.com/app/pAdkXIUXav6D4Iube2QG/data

[kyleheney]

That’s a weird one. I thought maybe it was a BEDMAS issue. Maybe try inserting a *1 to the end of your formula?

[V88]

Notice they’re all zero. Not a “row owner” thing by accident?

[Robert_Petitto]

Nope! Good try though.

[Robert_Petitto]

That worked. Weird.

[kyleheney]

I think I remember something from @Mark a while ago where they noticed results that should have been 1 were coming out as 0. It’s not a solution to the error, more a work-around until it’s fixed… but this method will always work even if the issue is actually fixed, so there’s no harm in doing this work-around.

[Robert_Petitto]

Related?
Relation when there shouldn’t be:

Template to Relation: Zero+ID

Data: Only 1’s+ID

[Robert_Petitto]

Fixed it. Had a stray row messing things up. If-Then-Else to the rescue!

[Mark]

@Robert_Petitto Can you still reproduce the original error? That shouldn’t happen.