community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Malformed If Statement (Please Help)

Highlighted
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!

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

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

Atom

THANK YOU!! This worked

Labels