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