FIXED

The FIXED function rounds a number to a specified number of decimal places, formats it in decimal notation, and returns the result as a number.

Supported Scenarios

The FIXED function is supported in the following YiDA scenarios:

FIXED(number, decimals)

Attribute	Required	Description
number	Yes	Number type. The number to round.
decimals	No	Number type. The number of digits to the right of the decimal point.

Return type	Description
Numerical	The number rounded to the specified number of decimal places.

As shown in the following figure, the FIXED() function rounds 3.141592657 to two decimal places.

Round the number to the second decimal place.