Crystal syntax.
Usage
$x
Converts x from number to currency.
Examples
The following examples are applicable to Crystal syntax.
Note: Each example assumes you have selected the following format options on the Number tab (Custom Style dialog box) of the Format Editor dialog box: Decimal places = (1.00), Negative sign = (345.00-), Currency symbol = (Float), and Thousands Separator = (1,000.00).
$12345678
Returns $12,345,678.00.
$(123 * 456)
Returns $56,088.00
$({file.QUANTITY} * 3)
Returns $42.00, where {file.QUANTITY} = 14.
$({file.MILES} * {file.PLEDGE})
$27.95, where {file.MILES} = 13 and {file.PLEDGE} = 2.15.
Note: You cannot multiply two currency values, doing so will result in an error.