accuracy of value

sunitha_cts · Post by **sunitha_cts** » Thu Oct 08, 2009 11:36 am

hi,

my source value as 12345.67 but i need only 12345.6value as my target
can anyone give a solution on this.

Thanks
sunitha

ArndW · Post by **ArndW** » Thu Oct 08, 2009 11:59 am

INT(In.MyNumericColumn*10)/10

Kryt0n · Post by **Kryt0n** » Thu Oct 08, 2009 2:42 pm

Read the documentation on (String|Decimal)ToDecimal, there are options to round towards 0, down or up

priyadarshikunal · Post by **priyadarshikunal** » Fri Oct 09, 2009 6:39 am

use decimaltodecimal(<input column>,"trunc_zero")
and set the column as (scale,1 as precision)

if you need to round it then use

decimaltodecimal(<input column>,"round_inf")