Simple IF than statement question

kas

I must be blind to something simple here, but can't see it...what's wrong with this statement? The error I get is "The field "" is not in the record. 

And if there is something better than Null() to create a blank result that'd be great too...

if [SSN] = "000000000" THEN Null() else [SSN] endif

Thanks!

Thableaus

Hi @kas

You're not giving a name to your new field in your Formula Tool.

If you want to keep it in your [SSN] column, you should select it right by the "+" button.

You must select or create a new field to use the Formula Tool.

Cheers,