Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
bonaiti
Contributor II
Contributor II

variable comma problem sum

Hi,

I have a problem with a variable with comma. I sum a field with the variable, but decimal not sum

See the image in the exemple!

HELP!error loading image

Robert

Labels (1)
2 Replies
Not applicable

hi,

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

thanks

bonaiti
Contributor II
Contributor II
Author

I solve.

SUM([Costo FDL]) + num('$(MP)', '#.##0,00')

Cool