DriveWorks Pro 17: Fixed [send feedback...]

Fixed

Returns a number rounded to the specified decimal places, with or without thousand separators (commas).

Syntax

Fixed([Number], [DecimalPlaces], [NoCommas])

Where:

Number is the number to round

Decimal places is the number of decimal places to return

NoCommas is either 0 (zero) or 1, 0 being include commas, 1 exclude commas.

Examples

Rule

Meaning
Fixed(1124.03, 1, 1)The function rounds the number 1124.03 to the defined number of decimal places (in this case; 1) and then removes all commas from the result. The result in this case is 1124.0.

Example Outcomes

NumberDecimalPlacesNoCommasOutcome
11940.7322011,940.73
9468.257219468.26

Table of Contents