We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multi-Field Formulas: how to convert several columns of values to the opposite sign

JokeFun
8 - Asteroid
‎11-05-2019 01:23 AM

I have several columns of data and would like to convert all of them to the opposite sign, say 100 need to be changed to -100. I don't what to write formula for each field to convert. I think the Multi-field Formulas should work. But I don't know which specific formula works here.

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
LukeM
Alteryx Alumni (Retired)
‎11-05-2019 01:24 AM

Hey @JokeFun 

This should be fairly simple.

Try this:

 

[_CurrentField_]*-1

 

 

Reply
0 Likes
JokeFun
8 - Asteroid
‎11-05-2019 01:43 AM

I just figured out. This should work.

[_CurrentField_]/-1

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All