Hi All,
I have a query that displays all records in negative values.
Can someone please tell me how I can convert them all to positive values?
i.e. Column value is -76000 expected result is 76000
Thanks.
Hi All,
I have a query that displays all records in negative values.
Can someone please tell me how I can convert them all to positive values?
i.e. Column value is -76000 expected result is 76000
Thanks.
Two methods
Abs(<<Value>>)
Or
X = Y*-1
David