Hi, I have a table below:
Profit | -100 |
Operating Cost | 20 |
Taxes | 20 |
Net Profit | -60 |
I need to change all negative numbers to positive and vice versa.
What's the quickest way to do it? I have an odd situation, whereby costs is shown as positive and revenue as negative....
Solved! Go to Solution.
Thanks Mark
Formula doesnt recognise "value" - i have the type of output as FixedDecimal...
What should i change value to?
Your sample data didn't have a field name. When using the formula tool, select the field that has that "value" in it and use the formula where you replace [Value] with the actual field name. In the following example, let's say that the field name is "Amount".
[Amount] * -1
That's how to change a value from positive to negative or negative to positive.
Cheers,
Mark