Negative to a positive number value and vice-versa

[GeckoPSU]

Hi everyone!

I can't seem to get this one but it seems as though it should be a simple calculation.

I'm trying to set up a calculation field that references a number field and returns positive value if it's negative and a negative value if it's positive.

Here's my approach which is apparently wrong:

[color:blue]

Case(

Amount < 0 ; Filter ( "1234567890." ; Amount );

"-" & Amount

)

I think it's wrong because when it references an amount like "-10,000" it returns "10". What happened to the other "0"s?

Thanks in advance.

[mr_vodka]

I would stick to simple mathematics here. ;-)

YourNumberField * -1

P.S. Make sure that YourNumberField is indeed a number field.

[GeckoPSU]

OMG I forgot my 2nd grade math skills. I'm going to crawl under my rock now. Thanks for your help.