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
14 - Magnetar

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

BS_THE_ANALYST_0-1679664956167.png

Mutiply the column by -1

 

BS_THE_ANALYST
14 - Magnetar

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

BS_THE_ANALYST_1-1679665007714.png

 

 

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