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: 
pnn44794
Partner - Specialist
Partner - Specialist

Dollar AMount Not Formatting as Expected

Hello:

I have the following as Text in Chart for a Gauge Chart and it is not formatting as I would expect it to.

=Num(Sum({$<CIO = {'Smith'}>} RangeMax([Finance Confirmed 2016 Savings], 0)), '$###0.00') & ' Of Goal'

The number I'm trying to format is 43175139.08 and the formatted result I'm looking for is $43.22.  I realize I probably have too many # signs, but I've tried multiple different combinations, none of which have worked.  With $###0.00, the result I get is $43175139.08.

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

If your number is as you say it is, I see no reason why your formatting should not work

Capture.PNG

Are you sure you don't have to multiple your expression by 1000000 to get what you want?

View solution in original post

7 Replies
vishsaggi
Champion III
Champion III

Can you try this?

=Num(Sum({$<CIO = {'Smith'}>} RangeMax([Finance Confirmed 2016 Savings], 0)), '$#0.00') & ' Of Goal'

sunny_talwar

If your number is as you say it is, I see no reason why your formatting should not work

Capture.PNG

Are you sure you don't have to multiple your expression by 1000000 to get what you want?

pnn44794
Partner - Specialist
Partner - Specialist
Author

Hello Vishwarath:

Thanks for the reply.  I get the same result.  Interestingly, if I provide an invalid CIO name, I don't get a sum, but it is in the right format.  For example, it formats as $0.00.

If you happen to reply again, I will check it out in the morning.  I have an appointment I need to go to now.  Thanks again.

pnn44794
Partner - Specialist
Partner - Specialist
Author

Hello Sunny:

Shoot.  I think you're right.  I have to multiply by 1 million.  Good catch.  I will definitely test this in the morning.

sunny_talwar

What do you see when you use just this in a text box object?

=Sum({$<CIO = {'Smith'}>} RangeMax([Finance Confirmed 2016 Savings], 0))

sunny_talwar

Sounds like a plan

pnn44794
Partner - Specialist
Partner - Specialist
Author

Hello Sunny:

Sorry for the delay in replying.  One of those days.  Anyway, I actually have to divide by 1000000.  It then works using the format Vishwarath provided.  I'll tag your reply about multiplying as correct because it made remember I needed to divide by 1MM.  Thanks again.