Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Malformed If Statement (Please Help)

Highlighted
5 - Atom

IF [month]="November" or [Month]="December" or [Month]="January" or [Month] = "February" or [Month] = "March" then [Average Balance Time Deposits]*.00113871445827391*30/360 else [Average Balance Time Deposits]*.00174198193414622*30/360

 

Can someone please help me understand what is wrong with the above if statement? Thank you!

Highlighted
12 - Quasar

Try adding "endif" to the end

 

IF [month]="November" or [Month]="December" or [Month]="January" or [Month] = "February" or [Month] = "March" then [Average Balance Time Deposits]*.00113871445827391*30/360 else [Average Balance Time Deposits]*.00174198193414622*30/360 endif

Highlighted
12 - Quasar

Hi again @JK15

 

I also wanted to add that you can alos make a list of your months in this syntax:

 

if [month] IN ("November","December","January","February","March") then [Average Balance Time Deposits]*.00113871445827391*30/360 else [Average Balance Time Deposits]*.00174198193414622*30/360 endif

Highlighted
5 - Atom

THANK YOU!! This worked

Labels