multi column sign flipping

[wlee-pwc]

I am trying to flip the sign to all the values in the screenshot (there a lot more columns than what the screenshot shows...at least 50 more).  What is the best way to go about it? 

Thank you in advance.

[jamielaird]

Hi @wlee-pwc 

You can transpose all the numeric columns (e.g. everything apart from Description) and then use a Formula tool to multiply everything in the Value column by -1, then Cross Tab to move your numeric data back into columns.

[Thableaus]

Hi @wlee-pwc 

Use Multi-Field Formula Tool selecting all Fields  and unchecking the option "Copy Output fields add"

[_CurrentField_] * -1

Cheers,

[danilang · Accepted solution]

Hi @wlee-pwc 

The most convenient way is by using the Multi-field tool.  

Select the fields you want to flip at the top and put 

-[_CurrentField_]

as the formula

Dan

[jamielaird]

@wlee-pwc the solution suggested by @Thableaus is better than mine :-)

[jamielaird]

@danilang @Thableaus we really need a system ;-)

[danilang]

@jamielaird @Thableaus 

Rock-Paper-Scissors is the only civilized way to handle these questions.  Or Rock-Paper-Scissors-Lizard-Spock if regular RPS always ends in a tie.

Dan

[Thableaus]

@danilang @jamielaird 

Well, what I do know is that the community always ends up winning! 

PS: I'm not a very lucky kind of guy. It wouldn't be fair.

Cheers,

[wlee-pwc]

Thank you very much everyone!

[wlee-pwc]

Thanks for the help again.  Another follow question, how do I include a and "if" in the multi field formula to exclude 0's?

Thanks in advance.