Number and date calculations performed in PDI do not apply the Format, Length, and Precision properties. For example, using the table below, A + B + B = 30.1 If you preview B, it will appear as 10.0, so you would think 10.02 + 10.0 + 10.0 = 30.02. However, because B was never converted to a string for the calculation, 10.02 + 10.04 + 10.04 = 30.1.
| Field | Input | Format | Decimal | Group | Length | Precision |
|---|---|---|---|---|---|---|
| A | 10.02 | #.0 | . | , | 5 | 1 |
| B | 10.04 | . | , | 5 | 1 |
If you want to truncate a string, use the Strings cut step.
If you want to round or truncate a number, use the following Calculator step features:
- Round function
- Floor and Ceil functions
Alternatively, you can convert the date or number to a string in the Select Values step, which applies the formatting specified in the metadata.