topic Change Positive Number to Negative and Vice Versa in Talend Studio https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264950#M44635 Hi, <BR />I need to change positive number to negative, and positive number to negative in the same column. <BR />Any suggestion? <BR />Amount <BR />923.54 <BR />-455.60 <BR />835.65 <BR />to <BR />Amount <BR />-923.54 <BR />455.60 <BR />-835.65 <BR />Regards <BR />Benjamin Marcus Thu, 20 Sep 2012 06:57:10 GMT Anonymous 2012-09-20T06:57:10Z Change Positive Number to Negative and Vice Versa https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264950#M44635 Hi, <BR />I need to change positive number to negative, and positive number to negative in the same column. <BR />Any suggestion? <BR />Amount <BR />923.54 <BR />-455.60 <BR />835.65 <BR />to <BR />Amount <BR />-923.54 <BR />455.60 <BR />-835.65 <BR />Regards <BR />Benjamin Marcus Thu, 20 Sep 2012 06:57:10 GMT https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264950#M44635 Anonymous 2012-09-20T06:57:10Z Re: Change Positive Number to Negative and Vice Versa https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264951#M44636 you can use the function "Mathematical.NEG()" in tmap Thu, 20 Sep 2012 07:14:10 GMT https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264951#M44636 Anonymous 2012-09-20T07:14:10Z Re: Change Positive Number to Negative and Vice Versa https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264952#M44637 Just have expression -&lt;column name&gt; e.g. -row1.myNum. <BR />For BigDecimals, use row1.myNum.negate(). Fri, 21 Sep 2012 07:48:04 GMT https://community.qlik.com/t5/Talend-Studio/Change-Positive-Number-to-Negative-and-Vice-Versa/m-p/2264952#M44637 alevy 2012-09-21T07:48:04Z