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.

IF Formula Question

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?



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.




8 - Asteroid

It worked perfectly! Thank you so much