Help With Text In Chart Expression Formatting Percentage

[pnn44794]

Hello:

I have a Funnel chart where under the Presentation tab, I'm attempting to add an expression in the Text in Chart section and append the output to some text as a percentage in XX% format.  However, I can't quite seem to get there.  The end result should be 85%, but it's formatted as 0.85075861677733.  The expression I'm using is:

=Num(Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0)),'$###0') / 14100000 & ' Booked + Not Booked Towards 100% of Goal'

Does anyone have any ideas?  I suspect I'm missing something simple.  As always, thanks in advance for any and all help and responses.

[sunny_talwar]

May be this

=Num(Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0))/14100000, '##%') & ' Booked + Not Booked Towards 100% of Goal'

[pnn44794]

Hello Sunny:

Thanks for the response.  I tried the expression and it returns 2.4e+08% instead of 85%.

[sunny_talwar]

How about this

=Num((Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0)))/14100000, '##%') & ' Booked + Not Booked Towards 100% of Goal'

[pnn44794]

That returns 0% instead of 85%.

[pnn44794]

Hold on.  I think I fat fingered it.  My apologies.

[sunny_talwar · Accepted solution]

One last try... may be this

=Num((Sum({$<CIO = {'Jones'}>} RangeMax([Finance Confirmed 2018 Savings], 0)) + Sum({$<CIO = {'Jones'}>} RangeMax([Estimated Save], 0)))/141000, '##%') & ' Booked + Not Booked Towards 100% of Goal'

[pnn44794]

I did fat finger it.  Again, my apologies.  I used a fake CIO name and forgot to change it to the correct one.  You're second solution works perfectly!!!!!  Thank you very much.  I appreciate it.  I will mark the answer as correct.

[pnn44794]

You’re second solution got it. It was my fault. I forgot to change the CIO name to a valid name. My apologies. I appreciate the help.