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

Alteryx designer Discussions

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

If a column contains one value, then convert the amount in a different column to a negatie

Highlighted
Meteor

So I have two columns, one column has values 1-5 named "Type". The second column is named "Dolllars" and has dollar amounts. I need to have a statement that IF column "Type" has a value of 2, then the dollar amount in the same row in "Dollars" column should convert to negative. 

 

I hope I explained what I'm trying to do good enough. Is this a formula function I assume? I'm not having luck getting this resolved.

Any direction is appreciated.

Alteryx Certified Partner

@dberroth 

 

Try

IF [Type] = '2'
THEN [Dollar] * -1
ELSE [Dollar]
ENDIF
Labels