Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

converting negative amounts into positive amount Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2008 3:51 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:02 AM
Points: 69, Visits: 255
Experts,
I have come accross a column that contains all paid orders but the amounts have a negative sign in front, how can I convert that netgative amount into a positve?

please help
Post #443305
Posted Tuesday, January 15, 2008 3:58 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:01 PM
Points: 3,843, Visits: 3,836
Multiply by -1.



John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
Post #443311
Posted Tuesday, January 15, 2008 3:59 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:41 PM
Points: 7,119, Visits: 15,009
Well - assuming you REALLY want to do this (I mean - they were entered in as negative values for a reason, weren't they?), look into the Books online for the ABS function. should do what you ask.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
Post #443314
Posted Tuesday, January 15, 2008 4:01 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:02 AM
Points: 69, Visits: 255
THANK YOU!!!!!!:)
Post #443315
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse