There are two possible workarounds:
An alternative workaround would be to check if the returned value is a zero and replace it with a NULL. This does depend on the base data not actually including any zeros as there is no way to know in Tableau if the value is a zero because it should be NULL, or because it is a zero.
There is currently no workaround for inserting NULL values for string fields in Tableau.
Hope this helps!