New Bug Encountered: When value is 0, TEXT() function returns empty string

AppSheet AppSheet Q&A
, ,
1

For any numeric data type, if the assigned value is zero, the TEXT() function returns an empty string. The expectation would be that the properly formatted zero value is returned - currency symbol and configured decimal places included.

Below is a table with some sample data. Note the circled row is where zero values are inserted but NOT returned from the TEXT() function.

3X_c_0_c0206f90f16b5ca9e8026e2a0f8de08b5046c9ec.png
3X_c_0_c0206f90f16b5ca9e8026e2a0f8de08b5046c9ec.png2890Ă—982 254 KB

2 Likes
2

Yep, I’d call that a bug!

Escalated.

1 Like
3

Thanks for reporting this @WillowMobileSystems ! We’re taking a look.

Shahaf

1 Like
4

@WillowMobileSystems we’re testing out a fix but in the meantime, I think this should help you get around the issue: change your expression from TEXT([Integer]) & " - Integer Result") to IF(OR([Integer] = 0, ISBLANK([Integer])), "0", TEXT([Integer])) & " - Integer Result".

Best,
Shahaf

2 Likes
5

Or:

ANY(LIST(TEXT([Integer]), "0") - LIST("")) & " - Integer Result"
3 Likes
6

Shahaf:

I think this should help you get around the issue: change your expression from TEXT([Integer]) & " - Integer Result") to IF(OR([Integer] = 0, ISBLANK([Integer])), "0", TEXT([Integer])) & " - Integer Result" .

Yes I did do something of this kind. In my case, the column is a Price column and wanted to be sure the currency symbol was included - (e.g. “$0 - No charges”).

7

Thanks for reporting this-- we’re deploying a fix for this, starting with all free users.

See the release notes here: December 8, 2021

2 Likes