If function error

AJ_AJ

Hi Guys,

I'm new to Alteryx.

I'm facing issues using If condition in my workflow. I guess the issue is with the String used.

My output what I need is if the if the days are more that 365 I want it to say "LT" if not then "ST"

Can someone help me with the issue. I have attached my sample workflow here.

Thanks for helping in advance.

Test Workflow3.yxmd

afv2688

Hello @AJ_AJ ,

When you put a number within quotes "365" means that you are using a string and not a number. If you want it to work first you have to change te value to number:

IF ToNumber([# Days])>365 THEN "LT" ELSE "ST" ENDIF

This way it should work

Cheers