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