I am trying to convert a string datatype to decimal data type using a Data Conversion Transformation.
My input is 1200080
my desired output is 12000.80 But what i get is 1200080.00
How do i include last two chars in the string as decimal.Thanks, Nk
asked Jul 19, 2011 at 03:12 AM in Default
In my experience when I have needed to convert a value like 1200080 to 12000.80 I simply multiply by .01
answered Jul 19, 2011 at 04:38 AM