Austin360Regular Visitor4 years agoSolvedConverting positive values to negative values Please I need help on how to convert positive values within a column to negative values. tamerj1 to Austin3604 years agoAustin360 You can also useNew Column =- ABS ( Table[Column] )tamerj1 to Austin3604 years agoAustin360 If you want convert all positive to negative and all negative to positive Column = - GL_ENTRY_[amount]
tamerj1 to Austin3604 years agoAustin360 You can also useNew Column =- ABS ( Table[Column] )tamerj1 to Austin3604 years agoAustin360 If you want convert all positive to negative and all negative to positive Column = - GL_ENTRY_[amount]
tamerj1 to Austin3604 years agoAustin360 If you want convert all positive to negative and all negative to positive Column = - GL_ENTRY_[amount]
tamerj1Community Champion4 years agoHi Austin360 New Column =IF ( Table[Column]<0, Table[Column], -Table[Column])
Austin360Regular Visitor to tamerj14 years agoThanks 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.
tamerj1Community Champion to Austin3604 years agoAustin360 If you want convert all positive to negative and all negative to positive Column = - GL_ENTRY_[amount]Austin360Regular Visitor to tamerj14 years agoThanks a million Austin360Regular Visitor to Austin3604 years agoColumn = 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
tamerj1Community Champion to Austin3604 years agoAustin360 If you want convert all positive to negative and all negative to positive Column = - GL_ENTRY_[amount]
Austin360Regular Visitor to Austin3604 years agoColumn = 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
Related contentConvert positive values to negativeConverting numbers from negative to positiveconvert positive number to negativeConverting all positive values in a column to negative values.How to convert negative numbers into positive numbers
