Page 1 of 1
Rounding to 2 decimal places
Posted: Thu Oct 14, 2010 11:22 pm
by prem84
My input column is decimal[20,4]
My values are 83.2356,98.2345
i want it to round to 2 decimal places
do i have to give my target as decimal[20,2]
i tried using decimal_to_decimal(inputcol,"ceil")
But no luck
Posted: Fri Oct 15, 2010 12:53 am
by prem84
Hi,
I resolved it there were some type coversion issues
Posted: Fri Oct 15, 2010 3:31 pm
by ray.wurlod
Please advise what these issues were, and how you discovered and resolved them. This will assist any future searchers who have the same problem. Then please mark this thread as Resolved using the green button at the top of the page.
Posted: Mon Oct 18, 2010 11:04 pm
by prem84
Hi Guys,
Sorry for the late update
Decimal_to_decimal(inputcolumnname,"ceil") works fine when rounding to 2 decimal places.My source column was decimal[20,4] and my destination i gave as Decimal[20,2].The problem i encountered error due to using a transformer and passing the modified column again to a target column of Decimal[20,4].I changed it to Decimal[20,2] and it works fine now.