Alteryx Designer Desktop Discussions

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

How to read a negative number to positive

Inactive User
Not applicable

Hi All,

 

How can i read a negative number as positive,example

A         B

-80      10

 

After addition result should be in positive e.g    90, Can anyone help me to achive this result.

 

Thanks in advance.

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Just wrap your fields that may be negative in abs(). In this case you would just do:

 

abs([A])+abs([B])

PhilipMannering
16 - Nebula
16 - Nebula

You can use `abs` function in the Formula Tool to take the absolute value.

PhilipMannering_0-1655217965638.png

 

Labels
Top Solution Authors