##### Page tree

Release 9.2

Contents:

Our documentation site is moving!

For up-to-date documentation of release 9.2 of Self Managed Designer Cloud, please visit us at https://help.alteryx.com/SMC/r92/.

Computes the degrees of an input value measuring the radians of an angle. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.
• Input units are in radians.

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

## Basic Usage

Numeric literal example:

`round(degrees(1.0000),4)`

Output: Returns the computation in degrees of `1.0000` radians, which is `57.2728`, rounded to 4 decimals.

Column reference example:

`degrees(myRads)`

Output: Returns the conversion of the values in `MyRads` column to degrees.

## Syntax and Arguments

`degrees(numeric_value)`

ArgumentRequired?Data TypeDescription
numeric_valueYstring, decimal, or integerName of column, Decimal or Integer literal, or function returning those types to apply to the function

### numeric_value

Name of the column, Integer or Decimal literal, or function returning that data type to apply to the function.

• Missing input values generate missing results.
• Literal numeric values should not be quoted. Quoted values are treated as strings.
• Multiple columns and wildcards are not supported.

Usage Notes:

Required?Data TypeExample Value
YesString (column reference) or Integer or Decimal literal`3.14`

## Examples

### Example - DEGREES and RADIANS functions

This example illustrates to convert values from one unit of measure to the other.

Functions:

ItemDescription
DEGREES Function Computes the degrees of an input value measuring the radians of an angle. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.
RADIANS Function Computes the radians of an input value measuring degrees of an angle. The value can be a Decimal or Integer literal or a reference to a column containing numeric values.
ROUND Function Rounds input value to the nearest integer. Input can be an Integer, a Decimal, a column reference, or an expression. Optional second argument can be used to specify the number of digits to which to round.

Source:

In this example, the source data contains information about a set of isosceles triangles. Each triangle is listed in a separate row, with the listed value as the size of the non-congruent angle in the triangle in degrees.

You must calculate the measurement of all three angles of each isosceles triangle in radians.

trianglea01
t0130
t0260
t0390
t04120
t05150

Transformation:

You can convert the value for the non-congruent angle to radians using the following:

Transformation Name `New formula` `Single row formula` `ROUND(RADIANS(a01), 4)` `'r01'`

Now, calculate the value in degrees of the remaining two angles, which are congruent. Since the sum of all angles in a triangle is 180, the following formula can be applied to compute the size in degrees of each of these angles:

Transformation Name `New formula` `Single row formula` `(180 - a01) / 2` `'a02'`

Transformation Name `New formula` `Single row formula` `ROUND(RADIANS(a02), 4)` `'r02'`

Create a second column for the other congruent angle:

Transformation Name `New formula` `Single row formula` `ROUND(RADIANS(a02), 4)` `'r03'`

To check accuracy, you sum all three columns and convert to degrees:

Transformation Name `New formula` `Single row formula` `ROUND(RADIANS(a02), 4)` `'checksum'`

Results:

After you delete the intermediate columns, you see the following results and determine the error in the checksum is acceptable:

trianglea01r03r02r01checksum
t01301.30951.30950.5238179.9967
t02601.04761.04761.0476179.9967
t03900.78570.78571.5714179.9967
t041200.52380.52382.0952179.9967
t051500.26190.26192.6190179.9967

• Page:
• Page: