Transforming value

[Anonymous]

Hi all,

I want to create an extra column like this below (NEW_VAL). Can you guys help me out?

So where the number is "30000" or "90000" the value needs to transform to a negative value.

Regards,

Ozgur 

[petrovnikitamai · Accepted solution]

NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])

try this

[petrovnikitamai · Accepted solution]

NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])

try this

[Anonymous]

Hi @petrovnikitamai

Additional, the the numbers are in another table (Table X) and the values are in another table (Table Y). Will that work?

Regards,

Ozgur

[petrovnikitamai · Accepted solution]

probably, not

but u can add column [Number] in your table  from other table with LOOKUPVALUE