topic Re: Format number without decimal separator ending with zeros in QlikView https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373555#M419515 <HTML><HEAD></HEAD><BODY><P>50,00 is not the 50. If it is decimal then it is 50.. Are you sure about expectation?</P></BODY></HTML> Mon, 16 Oct 2017 10:50:09 GMT Anil_Babu_Samineni 2017-10-16T10:50:09Z Format number without decimal separator ending with zeros https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373554#M419514 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to format number with 2 digits after decimal, but is those digits are ,00 then they will not appear.</P><P></P><P>Like if it is 50,40 it will be like this, if it is 50,00 it will make 50. If I choose fixed, it gives me 50,00</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179761_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Thank you.</P></BODY></HTML> Mon, 16 Oct 2017 10:47:56 GMT https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373554#M419514 retko1985 2017-10-16T10:47:56Z Re: Format number without decimal separator ending with zeros https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373555#M419515 <HTML><HEAD></HEAD><BODY><P>50,00 is not the 50. If it is decimal then it is 50.. Are you sure about expectation?</P></BODY></HTML> Mon, 16 Oct 2017 10:50:09 GMT https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373555#M419515 Anil_Babu_Samineni 2017-10-16T10:50:09Z Re: Format number without decimal separator ending with zeros https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373556#M419516 <HTML><HEAD></HEAD><BODY><P>Maybe use a conditional with different number formatting, like shown in</P><P><A href="https://community.qlik.com/message/807716">Round number when two digits after decimal is zero</A></P></BODY></HTML> Mon, 16 Oct 2017 11:00:15 GMT https://community.qlik.com/t5/QlikView/Format-number-without-decimal-separator-ending-with-zeros/m-p/1373556#M419516 swuehl 2017-10-16T11:00:15Z