Data Types

Pentaho Data Integration

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
Question
How do the data types work internally?
Suggested Solution
You might notice that if you multiply an integer and a number, the result is always rounded. The Calculator step uses the data type of the value to the left side of the multiplication calculation, in this case the value in Field A, as the driver for the calculation.

If you want more precision, place the value in Field B on the left side of the calculation. Alternatively, change the data type of Field A to Number.