Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Simple If Then formula used to calculate another field

CleverUserName
5 - Atom

I am new to Alteryx and am trying to create a simple formula: I need to take an amount in an existing column and multiply that column by -1 if there is an S.

 

 

CleverUserName_0-1613603611309.png

 

 

 

IF [Debit Credit Ind] = "S" THEN ([Amount in LC]*-1) ELSE [Amount in LC] ENDIF

 

1 REPLY 1
CleverUserName
5 - Atom

Please ignore. I realized it was due to a data type error. Thank you.

Labels