cancel
Showing results for 
Search instead for 
Did you mean: 

-ve value to +ve in db table

madan_ullasa
Contributor
0 Kudos

hi frnds!

any idea as to how to convert -ve values from db tab in our progs to +ve values. I kno that truncating is one way. is ther any other ??

eg..

i have the values : 1 , -6 , 10 , -5..

i want it to be 22 when i add them up..

madan .........

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

if TheValue < 0.

TheValue = TheValue * -1.

endif.

Or

Take the absolute value of each value - syntax is ABS (TheValue)

Please reward points appropriately.

Former Member
0 Kudos

Damn again the same question I'm kidding! Just in case the answer is bellow

Someone did just ask the question!

why don't you check the answer

But here is a copy paste of the answer:)

Hi !

1)

if number < 0.

number = number * ( -1 ).

endif.

2° BEST ONE

why don't you try ABS? (absolute value)

don't forget reward!!!!

Message was edited by: STEPHAN KAMINSKI

madan_ullasa
Contributor
0 Kudos

aarreeeeeeeeeyyyy..

stephe.....

the same thing here.

i had checked the radiobutton....

but the same thing ......

no points column..

i vill give a last try....

Former Member
0 Kudos

yes plz !

former_member185931
Participant
0 Kudos

var = abs(-ve field). will give you absolute value.

madan_ullasa
Contributor
0 Kudos

same prob dude ...

better luck next time dude...

sorry!!!

bye n take care.....