ABS Function

...

Column reference example:

ABS

d-codelang-syntax

abs(MyInteger) as:'abs_MyInteger'

abs(MyInteger)

Output: Generates the new abs_MyInteger column containing the Returns the absolute value of each value found in the MyInteger column.

Numeric literal example:

ABS

d-code-lang-syntax

abs(MyInteger) == 5)

(abs(MyInteger) == 5)

Output: Deletes all rows from the dataset in which the Returns true if the absolute value of the entry in the MyInteger column is 5.

D s

snippet	Syntax

ABS

d-code-lang-syntax

abs(numeric_value)

Argument	Required?	Data Type	Description
numeric_value	Y	string, decimal, or integer	Name of column or Decimal or Integer literal to apply to the function

...

You can use the following transform to derive the absolute values of these columns, which now measure distance from the fixed point:

d-

...

trans

...

abs(X) as: 'distanceX'

...

D trans

...

Results:

X	Y	distanceX	distanceY
-2	4	2	4
-6.2	-2	6.2	2
0	-4.2	0	4.2
4	4	4	4
15	-0.05	15	0.05

...

Versions Compared