Page 1 of 1
accuracy of value
Posted: Thu Oct 08, 2009 11:36 am
by sunitha_cts
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
Posted: Thu Oct 08, 2009 11:59 am
by ArndW
INT(In.MyNumericColumn*10)/10
Posted: Thu Oct 08, 2009 2:42 pm
by Kryt0n
Read the documentation on (String|Decimal)ToDecimal, there are options to round towards 0, down or up
Posted: Fri Oct 09, 2009 6:39 am
by priyadarshikunal
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")