DSXchange

I am facing a weird issue in multiplying a decimal field. My input data is defiend as Decimal(17,5) and output is also defined as Decimal(17,5).

Sample Input Values :
00000000171.38000
00000000371.63000
Output Values :
00000000000000171.38000
00000000000004459.56000

I have to multiple this with either 1,3,6 or 12 based on another field but when I do that and store in a separate field it gives me the following warning.

Returned value too large for field ANBP. Null used.

I even increased the result field to Decimal(22,5) and no use. What am I missing here ?

Thanks for your time...

My initial thought is that for the error row you are not multiplying by 12 as you assume, but by some other number.
Make a test copy of your job and make the output field a dfloat and write to a peek and see what value is displayed for the error row in question.