We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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