I have a column of type DT_NUMERIC(16,4) . How can I round to two digits, is that SSI in the derived column? I tried sound (column, 2) and it doesn't work for me.
DT_NUMERIC(16,4)
I also tried (DT_NUMERIC,16,4)ROUND([Column],2) , it doesn't work either
(DT_NUMERIC,16,4)ROUND([Column],2)
I currently have = 21.7000 I want =21.70
21.7000
21.70
Just try casting to (DT_NUMERIC,16,2) , use the following expression:
(DT_NUMERIC,16,2)
(DT_NUMERIC,16,2)ROUND([Column],2)
Also you can try the following:
ROUND(((DT_NUMERIC)([Column])), 2)
or
(DT_DECIMAL,2)[Column]