Converting positive values to negative values

[Austin360]

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

[tamerj1 · Accepted solution]

@Austin360 

You can also use

New Column =
- ABS ( Table[Column] )

[Austin360]

Thanks for the quick response 

[tamerj1 · Accepted solution]

@Austin360 

You can also use

New Column =
- ABS ( Table[Column] )

[tamerj1]

Hi @Austin360 

New Column =
IF ( Table[Column]<0, Table[Column], -Table[Column])

[Austin360]

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 · Accepted solution]

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

[Austin360]

Thanks a million 

[Austin360]

Column = if(GL_ENTRY_[amount] < 0, GL_ENTRY_[Amount] *-1,-GL_ENTRY_[Amount] *1)

was hoping this would do the trick.

But its not , Kindly help