DSXchange

How do I round off:

12.1 to 12
12.9 to 13
from a transformer

I tried NumericRound0 but it makes 12.1 to 12 & 12.9 also to 12.

The syntax for CEIL ?
CEIL(InputColumn) wont work.

Thanks for any help ...

Try DecimalToDecimal(InputColumn,"round_inf"). Make sure to set your output column to decimal with a scale of zero.