Format as a percentage

[fanninam]

Good Afternoon,

I'm trying to get the following to format as a percentage.  It is not working.  The number format is still showing as .0080831034482759 even when I use the script below:

='Sustain'&sum(TOTAL{$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#,##0%'

[sunny_talwar · Accepted solution]

I think you forgot the Num() function.... Try this:

='Sustain' & Num(Sum(TOTAL {$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#,##0%')

[vardhancse]

can try this once:

='Sustain'& NUM(sum(TOTAL{$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#0.00%')

[#4]

='Sustain'& NUM(sum(TOTAL{$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#0.00%')