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
Like -0.00?
This is not possible with Numeric Field Types.
You'd have to convert your fields to String Types and concatenate a "-" in front of the 0 values. But they wouldn't be numeric for calculations anymore.
Cheers,
Sorry, I meant the opposite. It is currently putting a "-" in front of the all the 0's so they look like -0. I want to exclude it. How would I include a command in the multi-field tool to flip the signs (like you have already shown in your first solution) but ignore 0's.