https://community.qlik.com/t5/Talend-Studio/round-to-2-dp-with-Float-ValueOf/m-p/2289541#M62913 Hi buzzy, <BR />What is the input data type? Also, float is only 32bit, so depending on the size of your number, you might lose precision after you round. Double or BigDecimal may be a better choice. <BR />For a double, you could use this to round: (Math.round(myField*100.0))/100.0 <BR />For a BigDecimal, you could use this to round: myField.setScale(2, BigDecimal.ROUND_HALF_UP) <BR />Thanks, <BR />Ben Tue, 22 May 2012 16:02:15 GMT Anonymous 2012-05-22T16:02:15Z https://community.qlik.com/t5/Talend-Studio/round-to-2-dp-with-Float-ValueOf/m-p/2289540#M62912 hi,<BR />pls let me know any one...<BR />round to 2 dp with Float.ValueOf()?<BR /><BR />thx Tue, 22 May 2012 13:04:08 GMT https://community.qlik.com/t5/Talend-Studio/round-to-2-dp-with-Float-ValueOf/m-p/2289540#M62912 Anonymous 2012-05-22T13:04:08Z https://community.qlik.com/t5/Talend-Studio/round-to-2-dp-with-Float-ValueOf/m-p/2289541#M62913 Hi buzzy, <BR />What is the input data type? Also, float is only 32bit, so depending on the size of your number, you might lose precision after you round. Double or BigDecimal may be a better choice. <BR />For a double, you could use this to round: (Math.round(myField*100.0))/100.0 <BR />For a BigDecimal, you could use this to round: myField.setScale(2, BigDecimal.ROUND_HALF_UP) <BR />Thanks, <BR />Ben Tue, 22 May 2012 16:02:15 GMT https://community.qlik.com/t5/Talend-Studio/round-to-2-dp-with-Float-ValueOf/m-p/2289541#M62913 Anonymous 2012-05-22T16:02:15Z