https://community.qlik.com/t5/QlikView/Format-number-correctly/m-p/1522210#M749003 <P>Sure, divide the number by 100 then format the result to display two decimals.</P> Tue, 18 Dec 2018 14:09:49 GMT Gysbert_Wassenaar 2018-12-18T14:09:49Z https://community.qlik.com/t5/QlikView/Format-number-correctly/m-p/1522206#M749002 <P>Hello,</P><P>&nbsp;</P><P>i'm loading numbers from a file wich look like 0000000000999.</P><P>With the num() function i get the number 999, but i want to have 2 decimals like 9,99.</P><P>However everytime I try to format it like num(CollumName,'#.###,#0') it doesn't take the last 2 Numbers as decimals, qlikview adds 2 zero's and it looks like 999,00.</P><P>Does anyone know how to format the collum so that the last 2 numbers are the decimals?</P> Sat, 16 Nov 2024 04:56:21 GMT https://community.qlik.com/t5/QlikView/Format-number-correctly/m-p/1522206#M749002 Lukas_H 2024-11-16T04:56:21Z https://community.qlik.com/t5/QlikView/Format-number-correctly/m-p/1522210#M749003 <P>Sure, divide the number by 100 then format the result to display two decimals.</P> Tue, 18 Dec 2018 14:09:49 GMT https://community.qlik.com/t5/QlikView/Format-number-correctly/m-p/1522210#M749003 Gysbert_Wassenaar 2018-12-18T14:09:49Z