
Contributor
2019-07-11
02:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Need to Add a Percent Symbol
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.
1,973 Views
1 Solution
Accepted Solutions

Master II
2019-07-11
03:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Num(Round(max({<[Col A]={MAX}>}[Col B])/100,0.01),'#0.00%')
1 is 100%
100 is 10000%
hope this helps
1,961 Views
1 Reply

Master II
2019-07-11
03:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Num(Round(max({<[Col A]={MAX}>}[Col B])/100,0.01),'#0.00%')
1 is 100%
100 is 10000%
hope this helps
1,962 Views
