Need to Add a Percent Symbol

[Lisa2]

Hello,

I need to add a percent symbol to the end of a result number being used in a gauge chart.  I have:

=Num(Round(max({<[Col A]={MAX}>}[Col B]),0.01),'#0.00%')

The rounded number comes out as 100.00 but when I add the percentage formatting it comes out as 10000.00% but I need it to be  100.00%

If someone could point me in the right direction.

Thanks.

[Frank_Hartmann · Accepted solution]

Num(Round(max({<[Col A]={MAX}>}[Col B])/100,0.01),'#0.00%')

1 is 100%

100 is 10000%

hope this helps