topic Remove decimal places from a Variable in QlikView https://community.qlik.com/t5/QlikView/Remove-decimal-places-from-a-Variable/m-p/384810#M1166234 <HTML><HEAD></HEAD><BODY><P>I have a variable that calculates a percentage and it currently returns 12 decimal places. Please can someone tell me how I can modify this to only return 2 or fewer dp?</P></BODY></HTML> Thu, 06 Sep 2012 09:32:13 GMT 2012-09-06T09:32:13Z Remove decimal places from a Variable https://community.qlik.com/t5/QlikView/Remove-decimal-places-from-a-Variable/m-p/384810#M1166234 <HTML><HEAD></HEAD><BODY><P>I have a variable that calculates a percentage and it currently returns 12 decimal places. Please can someone tell me how I can modify this to only return 2 or fewer dp?</P></BODY></HTML> Thu, 06 Sep 2012 09:32:13 GMT https://community.qlik.com/t5/QlikView/Remove-decimal-places-from-a-Variable/m-p/384810#M1166234 2012-09-06T09:32:13Z Re: Remove decimal places from a Variable https://community.qlik.com/t5/QlikView/Remove-decimal-places-from-a-Variable/m-p/384811#M1166235 <HTML><HEAD></HEAD><BODY><P>use num(Answer,'#,##0.00')</P><P>Hope this help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 06 Sep 2012 09:37:34 GMT https://community.qlik.com/t5/QlikView/Remove-decimal-places-from-a-Variable/m-p/384811#M1166235 rajni_batra 2012-09-06T09:37:34Z