Forum Discussion
Transforming value
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
NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])try this
probably, not
but u can add column [Number] in your table from other table with LOOKUPVALUE
3 Replies
NEW_VAL = IF([Number] in {30000;90000};[Value]*(-1);[Value])try this
Additional, the the numbers are in another table (Table X) and the values are in another table (Table Y). Will that work?
Regards,
Ozgur
probably, not
but u can add column [Number] in your table from other table with LOOKUPVALUE