Forum Discussion
netanel
6 years agoPost Prodigy
Need Help
Hello everyone, I have a little problem... I'm having a bit of trouble in the new version to solve this. I'm trying to multiply one column by minus 1 to make all the minuses a plus. can anyone he...
- 6 years ago
Measure = abs([col1]*-1 )
amitchandak
6 years agoSuper User
Measure = abs([col1]*-1 )
netanel
6 years agoPost Prodigy
Maybe I did not explain myself well, I want to exchange signs
Instead of minus plus
And instead of a plus minus
Thanks for your time
- littlemojopuppy6 years agoCommunity Champion
second column = [first column] * -1
You could actually prevent the need for this entirely within your data model by multiplying the value by -1 in the data transformation process