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

FIXED

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

Syntax

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

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.73220"11,940.73"
9468.25721"9468.26"

Table of Contents