Displaying decimal as percentage

Doga

I am summarizing the results of testing for a disease. I would like to show the positivity rate by year. In order to display positivity rate as a percentage, I need to define it as text and format it as a percentage adding % etc. However, if I use this approach I cannot plot the positivity rate by years as it is a text field, not decimal.

I don't want to show the testing rate as a decimal like "0.43" (it looks bad and more difficult to read) but I also want to plot it as a decimal.

Any ideas?

Turribeach

Simple solution. Use one field for display purposes and one field for plotting purposes.