topic variable comma problem sum in QlikView https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227522#M79630 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>probabaly in the number tab u should set number as number format settings and give the format pattern #,##0.00. and use . as a separator for decimal and , as a separator for thousand</P><P></P><P>thanks</P></BODY></HTML> Thu, 29 Apr 2010 08:41:47 GMT 2010-04-29T08:41:47Z variable comma problem sum https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227521#M79629 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a problem with a variable with comma. I sum a field with the variable, but decimal not sum</P><P>See the image in the exemple!</P><P></P><P>HELP!<IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1520_sourceID:1520" /></P><P>Robert</P><P></P></BODY></HTML> Thu, 29 Apr 2010 08:26:59 GMT https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227521#M79629 bonaiti 2010-04-29T08:26:59Z variable comma problem sum https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227522#M79630 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>probabaly in the number tab u should set number as number format settings and give the format pattern #,##0.00. and use . as a separator for decimal and , as a separator for thousand</P><P></P><P>thanks</P></BODY></HTML> Thu, 29 Apr 2010 08:41:47 GMT https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227522#M79630 2010-04-29T08:41:47Z variable comma problem sum https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227523#M79631 <HTML><HEAD></HEAD><BODY><P>I solve.</P><P></P><P>SUM([Costo FDL]) + num(<B>'$(MP)'</B>, '#.##0,00')</P><P></P><P><IMG alt="Cool" src="http://community.qlik.com/emoticons/emotion-11.gif" /></P></BODY></HTML> Thu, 29 Apr 2010 09:44:08 GMT https://community.qlik.com/t5/QlikView/variable-comma-problem-sum/m-p/227523#M79631 bonaiti 2010-04-29T09:44:08Z