Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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