Monarch Function Question

Melissa_21551

I have data that  gives me several totals.  I need to change the signs of value for each number.  So if the number is positive I need it to be negative and if the number is negative I need it to be positive.  Is there a function available that I can use to achieve this.  Or any other work around?  Below is an example of what I am looking for.

 

What I Have:                            What I need                                                        

                                                                             

TOTAL	Total Reversed
17,819,123.87-	17,819,123.87
32,220.36-	32,220.36
18,465,712.39	18,465,712.39-
7,597.36	7,597.36-

 

               Thank you!

 

Melissa

Altair Forum User

The easiest way to achieve this is to create a formula field and multiply the value by -1.