2 Replies Latest reply: Feb 24, 2017 8:17 AM by Melissa Falardeau RSS

    Monarch Function  Question

    Melissa Falardeau

      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                                                        

                                                                                   

      TOTALTotal Reversed
      17,819,123.87-17,819,123.87
      32,220.36-32,220.36
      18,465,712.3918,465,712.39-
      7,597.367,597.36-

       

                     Thank you!

       

      Melissa