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: 
ltc
Partner - Creator
Partner - Creator

Formatting a Dimension for Money

I have a dimension field that I'm formatting for money as follows:

=Money([Amount]/1000000)

So that's turning $10,333,333 into $10.33, but I need to see three decimal places to the right to show $10.333.  How do I do that?

Labels (1)
1 Solution

Accepted Solutions
ryo_okabe
Partner Ambassador
Partner Ambassador

Hi,

There are two ways to change money format.

 

1.Change [MoneyFormat] in data load editor.  This affect all money format.

WS0046.png

 

 

 

2.Change dimention to follows.This will only affect this dimension.

    =money([Amount]/1000000,'$#,##0.000;-$#,##0.000')

View solution in original post

1 Reply
ryo_okabe
Partner Ambassador
Partner Ambassador

Hi,

There are two ways to change money format.

 

1.Change [MoneyFormat] in data load editor.  This affect all money format.

WS0046.png

 

 

 

2.Change dimention to follows.This will only affect this dimension.

    =money([Amount]/1000000,'$#,##0.000;-$#,##0.000')