formula tool shows 0 instead of null in alteryx

[tanvir_khan]

Hi all:

I'm using a formula tool and trying to assign NULL in a string field but it shows 0 all the time. Can anyone please tell me why it's not assigning NULL. Thanks in advance.

thanks!

[Mateusz_Pietrzak · Accepted solution]

Hi,

You need to put only formula Null() without the indication to the field and it should work.

Your formula [Filed] = Null() is a logic condition which gives you a False as the result.