https://community.qlik.com/t5/Talend-Studio/How-to-use-BigDecimal-ROUND-HALF-UP-in-tMap/m-p/2333402#M102187 <P>Hello,</P><P></P><P></P><P>I have a problem with ROUND_HALP_UP.</P><P></P><P></P><P>I must use it in tMap but it doesn't work.</P><P></P><P></P><P>For exemple, I have this date "montant_ht" who is a double.</P><P></P><P></P><P>I would like to round it to the main neighbour.</P><P></P><P></P><P>So, I find the fonction "ROUND_HALF_UP' but I have a problem when I use it.</P><P></P><P></P><P>Where is my mistake ?</P><P></P><P></P><P>Kind regards.</P><P></P><P></P> Sat, 16 Nov 2024 00:22:37 GMT Eric_Talend 2024-11-16T00:22:37Z https://community.qlik.com/t5/Talend-Studio/How-to-use-BigDecimal-ROUND-HALF-UP-in-tMap/m-p/2333402#M102187 <P>Hello,</P><P></P><P></P><P>I have a problem with ROUND_HALP_UP.</P><P></P><P></P><P>I must use it in tMap but it doesn't work.</P><P></P><P></P><P>For exemple, I have this date "montant_ht" who is a double.</P><P></P><P></P><P>I would like to round it to the main neighbour.</P><P></P><P></P><P>So, I find the fonction "ROUND_HALF_UP' but I have a problem when I use it.</P><P></P><P></P><P>Where is my mistake ?</P><P></P><P></P><P>Kind regards.</P><P></P><P></P> Sat, 16 Nov 2024 00:22:37 GMT https://community.qlik.com/t5/Talend-Studio/How-to-use-BigDecimal-ROUND-HALF-UP-in-tMap/m-p/2333402#M102187 Eric_Talend 2024-11-16T00:22:37Z https://community.qlik.com/t5/Talend-Studio/How-to-use-BigDecimal-ROUND-HALF-UP-in-tMap/m-p/2333403#M102188 <P>Hi </P><P>The function ROUND_HALF_UP&nbsp;is defined for BigDecimal, so you need to convert double type to BigDecimal type first. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Thu, 08 Apr 2021 07:28:06 GMT https://community.qlik.com/t5/Talend-Studio/How-to-use-BigDecimal-ROUND-HALF-UP-in-tMap/m-p/2333403#M102188 Anonymous 2021-04-08T07:28:06Z