topic Straight table, remove decimal in QlikView https://community.qlik.com/t5/QlikView/Straight-table-remove-decimal/m-p/1442205#M798002 <HTML><HEAD></HEAD><BODY><P>HI&nbsp; i have a amount in dollar and cents . how to remove cents value and also $ sign. </P><P></P><P>for eg&nbsp; $316.25&nbsp;&nbsp;&nbsp;&nbsp; i only want 316</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT everest226 2020-11-25T16:16:04Z Straight table, remove decimal https://community.qlik.com/t5/QlikView/Straight-table-remove-decimal/m-p/1442205#M798002 <HTML><HEAD></HEAD><BODY><P>HI&nbsp; i have a amount in dollar and cents . how to remove cents value and also $ sign. </P><P></P><P>for eg&nbsp; $316.25&nbsp;&nbsp;&nbsp;&nbsp; i only want 316</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-table-remove-decimal/m-p/1442205#M798002 everest226 2020-11-25T16:16:04Z Re: Straight table, remove decimal https://community.qlik.com/t5/QlikView/Straight-table-remove-decimal/m-p/1442206#M798004 <HTML><HEAD></HEAD><BODY><P>Go to the number's tab and change the format from $#,##0.00 to $#,##0</P><P></P><P>or if you are using a num function for the format, then change the format there</P></BODY></HTML> Wed, 06 Dec 2017 20:24:28 GMT https://community.qlik.com/t5/QlikView/Straight-table-remove-decimal/m-p/1442206#M798004 sunny_talwar 2017-12-06T20:24:28Z