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

Syntax

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

This function rounds the value of Number to the number of decimal places defined by DecimalPlaces and applies the selected comma format, dependant on the NoCommas value.

If NoCommas contains any value other than zero or nothing, then commas will be removed from the returned value.

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