DSXchange

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.

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

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.

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