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.
|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".|