Change negative to positive numbers and vice versa

[nfoong]

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....

[MarqueeCrew]

Formula of:

[value] * -1

Should do the trick!

Cheers,
Mark

[nfoong]

Thanks Mark

Formula doesnt recognise "value" - i have the type of output as FixedDecimal...

What should i change value to?

[MarqueeCrew · Accepted solution]

@nfoong,

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