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.