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

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.

2 REPLIES 2
LukeM
Moderator
Moderator

Hey @JokeFun 

This should be fairly simple.

Try this:

 

[_CurrentField_]*-1

 

 

JokeFun
8 - Asteroid

I just figured out. This should work.

[_CurrentField_]/-1

Labels
Top Solution Authors