Page tree


The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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.
  • A unit of 1 radian identifies the angle of a circle where the radius of the circle equals the length of the arc on the circle for that angle. This value corresponds to approximately 57.3 degrees.
  • Input units are in degrees.
  • You can convert from radians to degrees. For more information, see DEGREES Function.

Basic Usage

Numeric literal example:

derive type:single value: ROUND(RADIANS(57.2728),4)

Output: Generates a column containing the computation in radians of 57.2728 rounded to four digits, which is 1.0000.

Column reference example:

derive type:single value: RADIANS(myDegrees) as: myRads'

Output: Generates the new myRads column containing the conversion of the values in MyDegrees column to radians.


derive type:single value: RADIANS(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

For more information on syntax standards, see Language Documentation Syntax Notes.


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 literal10


Example - DEGREES and RADIANS functions

This example illustrates to use the DEGREES and RADIANS functions to convert values from one unit of measure to the other.


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.



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

derive type:single value: ROUND(RADIANS(a01), 4) as: '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:

derive type:single value: (180 - a01) / 2 as: 'a02'

Convert the above to radians:

derive type:single value: ROUND(RADIANS(a02), 4) as: 'r02'

Create a second column for the other congruent angle:

derive type:single value: ROUND(RADIANS(a02), 4) as: 'r03'

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

derive type:single value: ROUND(DEGREES(r01 + r02 + r03), 4) as: 'checksum'


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


Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 6 rates

This page has no comments.