Forum Discussion

Austin360's avatar
Austin360
Regular Visitor
4 years ago
Solved

Converting positive values to negative values

 

Please I need help on how to convert positive values within a column to negative values. 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Austin360 
    If you want convert all positive to negative and all negative to positive 
    Column = - GL_ENTRY_[amount]

7 Replies

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      Austin360 

      You can also use

      New Column =
      - ABS ( Table[Column] )

    • Austin360's avatar
      Austin360
      Regular Visitor
      4 years ago

      Thanks alot.

       

      I was hoping to use an else statement alongside your statement above to change the all negative to positive. 

       

      Like all positive to negative and negative to positive. 

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Austin360 
        If you want convert all positive to negative and all negative to positive 
        Column = - GL_ENTRY_[amount]