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.
Solved! Go to Solution.
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.
Hi @wlee-pwc
Use Multi-Field Formula Tool selecting all Fields and unchecking the option "Copy Output fields add"
[_CurrentField_] * -1
Cheers,
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
@wlee-pwc the solution suggested by @Thableaus is better than mine :-)
@danilang @Thableaus we really need a system ;-)
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
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,
Thank you very much everyone!
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.