Change any character to a null

Some applications can insert a character into a field instead of keeping it a blank/null value. This can cause issues when visualizing data as often times in visualizations that value (usually a hyphen) will show up but not really tell you any information. To clean up our visualizations we can turn those values into nulls and then exclude the null values.

To change a character to a null use the following forumela:

If([col] = ‘’, null, [col])


If([col] = ‘-’, null, [col])

Credit: Rob W