Skip to Content

-ve value to +ve in db table

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 .........

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 07, 2005 at 12:33 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Oct 07, 2005 at 12:35 PM

    if TheValue < 0.

    TheValue = TheValue * -1.

    endif.

    Or

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

    Please reward points appropriately.

    Add comment
    10|10000 characters needed characters exceeded