Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
If your number is as you say it is, I see no reason why your formatting should not work
Are you sure you don't have to multiple your expression by 1000000 to get what you want?
Can you try this?
=Num(Sum({$<CIO = {'Smith'}>} RangeMax([Finance Confirmed 2016 Savings], 0)), '$#0.00') & ' Of Goal'
If your number is as you say it is, I see no reason why your formatting should not work
Are you sure you don't have to multiple your expression by 1000000 to get what you want?
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.
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.
What do you see when you use just this in a text box object?
=Sum({$<CIO = {'Smith'}>} RangeMax([Finance Confirmed 2016 Savings], 0))
Sounds like a plan
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.