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.
Just wrap your fields that may be negative in abs(). In this case you would just do:
abs([A])+abs([B])
You can use `abs` function in the Formula Tool to take the absolute value.
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |