Creating an IF Statement in the Formula Tool

[Andrew_Seaman]

I need to create an if statement that creates a new column, but I'm running into Syntax issues.

IF [TIME] IS NOT NULL

THEN .027

ELSE

NULL

END AS [NEW FIeld]

What is the Alteryx syntax for this?

[AbhilashR · Accepted solution]

The syntax would be

IF !(ISNULL([TIME]) THEN 0.27

ELSE NULL()

ENDIF

Remove the space in ENDIF