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 · Accepted solution]

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,

[kas]

Good grief...I knew I was just being blind...must still have holiday brain...

---

@Thableaus wrote:

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,

---

Thanks so much!