4 Replies Latest reply: Jun 23, 2016 7:23 AM by Roy Givens RSS

    Formula to change a positive number to negative

    Roy Givens

      I have a calculated field that is pulling in positive numbers from a pdf. I need to convert all of them to negative numbers, but cannot figure out the syntax to do this. I would really appreciate any help you can give me.

       

      example:

       

      CalcField1:

      25,000

      30,000

      15,000

       

      CalcField2 (Result)

      -25,000

      -30,000

      -15,000