https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375331#M137767 Hi, <BR />Thanks for your feedback.<BR />Best regards<BR />Sabrina Thu, 22 Aug 2013 08:30:58 GMT Anonymous 2013-08-22T08:30:58Z https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375327#M137763 can anyone give me a tip how to get decimals when divide two numbers? <BR />output is Double <BR />I get the output 0.0 <BR />How do i get 0.1??? <BR />output_row.price =1.0/10 Wed, 21 Aug 2013 13:22:05 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375327#M137763 Anonymous 2013-08-21T13:22:05Z https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375328#M137764 Hi, <BR />If I understand you well, do you want to convert Double to Decimal after the divide operation? <BR />Best regards <BR />Sabrina <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MAr8.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/131365iA16F56EF261A0BBF/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MAr8.png" alt="0683p000009MAr8.png" /></span> Thu, 22 Aug 2013 05:02:38 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375328#M137764 Anonymous 2013-08-22T05:02:38Z https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375329#M137765 <BLOCKQUOTE> <TABLE border="1"> <TBODY> <TR> <TD>can anyone give me a tip how to get decimals when divide two numbers?<BR />output is Double<BR />I get the output 0.0<BR />How do i get 0.1???<BR />output_row.price =1.0/10</TD> </TR> </TBODY> </TABLE> </BLOCKQUOTE> <BR />Is this the real expression? You should not have an issue if your output row is defined as double. <BR />You could try 1.0d/10d <BR />But this expression looks okay to me <BR />Your result suggests that you're getting and integer division that is then converted to a double Thu, 22 Aug 2013 07:17:53 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375329#M137765 Anonymous 2013-08-22T07:17:53Z https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375330#M137766 Thanks! <BR />A mixture between both worked: <BR />new java.math.BigDecimal((double)(TalendDate.diffDate(rowHoved.TrombolyseStarttid,rowHoved.Innleggelsestidspunkt,"ss"))/3600d) Thu, 22 Aug 2013 08:00:47 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375330#M137766 Anonymous 2013-08-22T08:00:47Z https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375331#M137767 Hi, <BR />Thanks for your feedback.<BR />Best regards<BR />Sabrina Thu, 22 Aug 2013 08:30:58 GMT https://community.qlik.com/t5/Talend-Studio/how-to-get-decimals-when-divide-two-numbers/m-p/2375331#M137767 Anonymous 2013-08-22T08:30:58Z