Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to add Negative sign to all value?

phoebe_90
8 - Asteroid

change sheet1 to sheet2

AccountAmount
245082106.68
68121000-6.68
2450821033.85
245082104.28
2450821024.00
2450821031.56
2450821064.46
2450821048.13
64015000

-48.13

65031000-33.85
65080000-24.00
66010000-677.32
66020000-4.28
66020000-31.56
66020000-64.46

sheet2

AccountAmount
24508210-6.68
681210006.68
24508210-33.85
24508210-4.28
24508210-24.00
24508210-31.56
24508210-64.46
24508210-48.13
24508210-677.32
6401500048.13
6503100033.85
6508000024.00
66010000677.32
660200004.28
6602000031.56
6602000064.46
4 REPLIES 4
BS_THE_ANALYST
15 - Aurora
15 - Aurora

@phoebe_90 you just need to use a formula tool like so:

BS_THE_ANALYST_0-1679664956167.png

Mutiply the column by -1

 

All the best,
BS

LinkedIN

Bulien
BS_THE_ANALYST
15 - Aurora
15 - Aurora

@phoebe_90 if you want to overwrite the existing column, instead of creating a new one:

BS_THE_ANALYST_1-1679665007714.png

 

 

All the best,
BS

LinkedIN

Bulien
JitendraPal
7 - Meteor

First of all, change the data type for the Amount field to either Double or Float by using select tool, then use the formula tool ([Amount]* (-1)) to get the desired result. 

 

JitendraPal_0-1679665775102.png

 

Arjunmarwaha09
8 - Asteroid

looks good

Labels
Top Solution Authors