https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324445#M94145 Use (float) to convert your integer number division to float in tMap. say (float)(A/B). You already have your output column as float. So it should work. <BR />Vaibhav Fri, 18 Apr 2014 06:23:35 GMT Anonymous 2014-04-18T06:23:35Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324444#M94144 Hi, <BR />I'd like to generate a calculated metric in my Talend job, namely a percent <BR />At this point I have tried dividing two integer columns A / B in a tMap with the data type set to Float <BR />I'm not getting decimal values through to my MySQL table; they're showing up as integers <BR />My MySQL column is set to decimal data type length of '5,2' <BR />I don't have a length specified in my Talend schema as I didn't know how to express it <BR />Could use some help in getting my percentage working <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />Thanks Thu, 17 Apr 2014 23:01:51 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324444#M94144 Anonymous 2014-04-17T23:01:51Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324445#M94145 Use (float) to convert your integer number division to float in tMap. say (float)(A/B). You already have your output column as float. So it should work. <BR />Vaibhav Fri, 18 Apr 2014 06:23:35 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324445#M94145 Anonymous 2014-04-18T06:23:35Z https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324446#M94146 Hi, and thanks <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MACn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154443iC5B8CACEF3D12C6A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MACn.png" alt="0683p000009MACn.png" /></span> <BR />I ended up just using the (float) on the first int, since that also works: <BR />(float)row.col1/row.col2 Tue, 22 Apr 2014 18:36:19 GMT https://community.qlik.com/t5/Talend-Studio/How-to-create-a-float-by-dividing-two-int-s/m-p/2324446#M94146 Anonymous 2014-04-22T18:36:19Z