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

[WillowMobileSys]

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.

[Steve]

Yep, I’d call that a bug!

Escalated.

[Shahaf]

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

Shahaf

[Shahaf]

@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

[Steve]

Or:

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

[WillowMobileSys]

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”).

[Shahaf]

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

See the release notes here: December 8, 2021