The PI function generates the value of pi to 15 decimal places: 3.1415926535897932.

This function uses no parameters. Generated values are of Decimal type and have fifteen digits of precision after the decimal point. If you want to see a fewer number of digits in the generated value, you might need to apply a different number format or using the ROUND function.

derive type:single value: PI() as:'pi_col'

Output: For each row, generate the value of pi.

There are no arguments for this function.

Example - pi column

In the following example, the source is simply the source column, and the pi column is generated by the PI function:

derive type:single value:PI() as:'pi'

sourcepi
A

3.1415926535897932

B

3.1415926535897932

C

3.1415926535897932

D

3.1415926535897932

Example - RANDBETWEEN, PI, and TRUNC functions