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

How to change the negative value to positive value

Meteor

Can someone please help me with the formula to change the negative value to positive and in the same column I have the positive value as well and it shouldn't be changed.

 

 

Amt

   5

-15

  25

-35

Magnetar
Magnetar

Hi,

 

The ABS() function in the Formula tool will do this by getting the absolute value for each of these.

 

 

ABS([Amt])

Should do it.

Meteor

@Claje thank you so much, it worked

Labels