DECIMAL (Report Builder 1.0)
Converts a value to a decimal.
Syntax
DECIMAL(value)
value |
Indicates the number to convert to a decimal. |
Remarks
- You can specify the number of decimal places after the decimal by using the Number tab on the Format dialog box.
Example
Formula |
Result |
---|---|
DECIMAL(Vacation Hours) |
Converts each instance of the Vacation Hours field into a decimal and returns data that looks similar to the following: 99.00 98.00 |
DECIMAL(3) |
3.0 |