Don't want to round off

[rameshkm]

Hi All,

I have a column as decimal with length 22 and precision as 12 in sql server, in datastage for the column have many arithmetic function (ie addition, subtraction and division ) with same with length 22 and precision as 12, when I test the values with XL Sheet(precision as 12 ) with same operation whatever in datastage the result is not same , it getting round off after four values from the decimal point, please help in this, Thanks in advance.

[rameshkm]

Hi Friends,
This thing is happening when the column undergone on multiplication, please help As Soon As Possible.

[vinnz]

Please post some examples and the derivations that you used.

[rameshkm]

In XL Sheet
12000000.000000000000 * 0.934448160535 = 11213377.926421400000

In Data stage
12000000.000000000000 * 0.934448160535 = 0011213377.926420000000

See there is round off after 4 digits from the decimal point

the derivation i used is [remaning_multiplier* factor_schedule]

i used this derivation in the stage variable all its datatype are Decimal(22,12)