Using an If/Else Column Step
Use this step to populate a new column with the absolute values of another.Steps
First, create the new step:1
Add an If/Else Column step
2
Select a name for your new column
1
Under “If this is true” select your input column and “is greater than or equal to”
2
enter 0 in the Condition box
3
Under “Then set the value to”, put
{input column name}1
Click ”+ Add a rule”
2
Under “else, if this is true” select your input column and “Is less than”
Enter 0 in the condition box
3
Enter 0 in the condition box
4
Underneath “then set the value to”, click the gear icon
5
Make sure the “Accepts math functions” checkbox is checked
6
Under “Then set the value to”, put
{input column name} * -1Using the Find and Replace step
A simpler solution can be to use Find and Replace to treat the number as a string and replace the negative sign (-) with nothing.Steps:
1
Add a Find and Replace step.
2
Select the column with the negative values.
3
Set it to find ”-” and replace with nothing. Make sure you’re searching for “in any part of a cell” and replacing “in any part of the cell”.