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

Syntax

DOLLAR( [ Value], [ DecimalPlaces] )

This function converts the Value to a string and applies the default currency formatting.

The DecimalPlaces value denotes the number of decimal places required in the string. If more decimal places are required than are present in the string, then the rest of the decimal places are made up of zero's. If less are required, then the number value is rounded off to the nearest decimal unit to match the number of decimal places required.

Examples

Rule

Meaning
DOLLAR(123456, 2)The function takes the value of 123456 and converts it to a string with the default currency formatting applied. This results in "£123,456". The function then takes the decimal places value and applies it to the currently formatted value. In this case, two decimal places are required, so the final outcome is "£123,456.00".

Example Outcomes

ValueDecimalPlacesOutcome
1234562"£123,456.00"
1234.564"£1,234.5600"
123.4561"£123.5"
123456.7892"£123,456.79"

Table of Contents