Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mrmatt
Contributor III
Contributor III

Money format pattern not producing expected result

Hello,

I have a number which defaults like this: 100260943.07 which I want to  format as a currency. I used a custom format of this: $#,##0.00 and the result was this:  $100260943,##0.00. However my expected/desired result is this:  $100,260,943.07.

What am I doing wrong and/or how do I modify the format to obtain my desired result?

thanks,

 

Labels (2)
11 Replies
y_grynechko
Creator III
Creator III

Is there any currency set up in the load script? 

What extension are you using? You have a little more options that the plain qlik sense table. 

mrmatt
Contributor III
Contributor III
Author

@y_grynechko yeah I'm beginning to think it's something on my companies server settings because I tried and this works fine in the desktop version. thanks,