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