How to round the numeric values

MVL · Post by **MVL** » Fri Oct 03, 2008 5:11 am

Hi

I want to round the values to 2 decimal places. How can it be done in PX? and in which stage?

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 5:24 am

What is the current data type that you want to round, and what is the data type of the field where you want to store the result. Knowledge of both of these things is essential before one can choose the correct function.

MVL · Post by **MVL** » Fri Oct 03, 2008 5:33 am

Thanks Ray for reply.

Input column is Decimal(38,4). I want to round it to 2 decimal places.
Oh and I think that would be done if I just mention precision = 2 in output column of transformer...(?). Your views please?

ray.wurlod · Post by **ray.wurlod** » Fri Oct 03, 2008 6:28 am

Depends. What is the data type of the output column? As I stated, one needs to know both to determine whether an implicit conversion can be done or whether to override the default rounding strategy or whether an explicit function is required.