Need to Add a Percent Symbol

Lisa2 — Sat, 16 Nov 2024 20:28:25 GMT

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.

Re: Need to Add a Percent Symbol

Frank_Hartmann — Thu, 11 Jul 2019 19:01:21 GMT

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

1 is 100%

100 is 10000%

hope this helps