I am trying to apply % for a chart where result is between 0.00 to 0.99 and would like to display as %
When I apply number format it displays as 66.66% or so on. i want it to be 0.66% instead. Can you please suggest the number format
I used ##.00% and few others but dint work.
Divide the number by 100 and you will get the expected result.
Please check this. Thank you.
Or you can just add '%' to the number:
Did you able to manage to get the solution? Thank you.
First Divide your expression by 100
than Go to Number Tab option > Select the Expression on which you want to show
the Percentage Sign (%) and Select Fixed to option and Check Show in Percent (%) option.
Retrieving data ...