Applying calculations and rounding

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.