Forum Discussion
netanel
Post Prodigy
6 years agoNeed 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
- amitchandak
Super User
Measure = abs([col1]*-1 )
- netanel
Post 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
- 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
- Greg_Deckler
Community Champion
Can you just use ABS function? ABS([Column])