Forum Discussion
netanel
Post Prodigy
Post ProdigyNeed 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...
Measure = abs([col1]*-1 )
amitchandak
Super User
Super UserMeasure = abs([col1]*-1 )
netanelPost Prodigy
Post ProdigyMaybe 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
- littlemojopuppy
Community 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
