Assign negative values to variable values

[#1]

Hello,

i have a very simple question, in which i wasn't able to find a solution from google.

Here is the sample of my table:

Item

Quantity

Price

I just want to make all Quantity values negative. I tried Quantity*(-1) but it didn't work. Can anyone please suggest a way to acomplish that?

Thank you in advance

[swuehl]

This should work if you are using this as calculated field in the LOAD script or a UI expression.

Also, your Quantity values should be numeric, not just pure text values.

[Anonymous]

It should work.. Can you post your variable expression !!

[Anonymous · Accepted solution]

Try this

num#(Quantity,'#')*-1 as Quantity

[#5]

It worked finally! Thanks for your suggestions