Help with formula

[Talbanese]

Hello,

I'm trying to get the formula to calculate IIF([Day Span]<=30,1,0) using the formula tool.

I'm getting an error saying "Invalid type in operator" I'm sure this is a syntax error but still learning the Alteryx language.

Thanks for the help :).

[MarqueeCrew · Accepted solution]

Is [dayspan] a number or a string?  If you are comparing to 30, it needs to be a number. 

You are also assigning the values of 0 & 1. Is the new field a Boolean or number?  

Thanks,

mark

[Talbanese]

Thanks Mark,

Needed to change the type since it was a number.

:).