We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

IF Formula Question

Cferrer6
8 - Asteroid

Hi all,

 

I am new to Alteryx. Does anyone know how to complete an If formula for below? 

 

Attached Photo shows my report. IF the number is negative (or less than 0) then i want to multiple it by -1 to make it positive AND i want to change the rmk from 63 to 13. Any suggestions?

 

 

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

Both of these can be accomplished with a conditional statement in a formula.

 

I started by updating the Rmk field. I created a statement to say if AR <0 then change it to 13, otherwise leave it as is. I then used a similar formula to multiple AR by -1 if negative.

 

echuong1_0-1612843570237.png

 

Cferrer6
8 - Asteroid

It worked perfectly! Thank you so much

Labels