chopping decimals

scorpion · Post by **scorpion** » Wed Dec 05, 2007 3:25 am

all,

i am getting values in my output file for one of my columns are like:

102.34
-103.68
108.98
-45.08
etc etc

but requirement is to get absolute values(to remove '-' symbol)

i used Abs function in my transformer for that perticular calculation,but when i tried with the function ,the decimals are chopped off.

i am getting values like..

102,
103.
108
etc etc.....

how to get absolute values without decimal values are chopped off.

thanks for the help.

Maveric · Post by **Maveric** » Wed Dec 05, 2007 3:35 am

You might want to investigate the function called Neg under Mathematical.

landaghaar · Post by **landaghaar** » Wed Dec 05, 2007 8:15 am

in the worst case, put an If statement and if any number is < 0 then multiply it by -1 else take it as it is.

ArndW · Post by **ArndW** » Wed Dec 05, 2007 10:50 am

If you have fixed decimal to 2 places, do "ABS(In.Column*100)/100"