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.
IF [Debit Credit Ind] = "S" THEN ([Amount in LC]*-1) ELSE [Amount in LC] ENDIF
Solved! Go to Solution.
Please ignore. I realized it was due to a data type error. Thank you.