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 help me?
Measure = abs([col1]*-1 )
4 Replies
- amitchandakSuper User
Measure = abs([col1]*-1 )
- netanelPost Prodigy
Maybe I did not explain myself well, I want to exchange signs
Instead of minus plus
And instead of a plus minusThanks for your time
- littlemojopuppyCommunity 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
- Greg_DecklerCommunity ChampionCan you just use ABS function? ABS([Column])