Page 1 of 1
Rounding in PX
Posted: Fri Jun 29, 2007 6:00 am
by kd813
I have a decimal input and wanted to round it to one decimal place
ie if input is 2.34 output should be 2.3
ans if IP is 2.19 OP should be 2.2
Kindly provide a solution as to how to achieve this
Posted: Fri Jun 29, 2007 6:36 am
by ray.wurlod
Please delete duplicate post.
Take a look at the Parallel Job Developer's Guide - in particular number conversion functions. Differentiate ceil, floor, round_inf and trunc_zero.
Please post your research findings.
Posted: Fri Jun 29, 2007 6:38 am
by kd813
i have tried using DecimalToDecimal(Link.Field,'round_inf') but this is not giving me the desired output
Posted: Fri Jun 29, 2007 7:48 am
by DSguru2B
What are you getting and what is your desired result? Also keep in mind that the rounding will take place keeping your specified scale in the metadata. WHat is the metadata of your source and target column?