Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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