Crystal Reports – How to format number as percentage

The following steps describe how to format a number so that it looks like a percentage.

The obvious thing to point out is that there is no true ‘percentage’ value in Crystal Reports – but you can take a number and format it so that it ends with a percent symbol. That is, 55.23 displayed as 55.23 %.

First – if your value is currently a decimal, e.g. 0.5523, you will need to times is by 100 to shift the decimal place to 55.23.

To do this,

  1. Right-click on formula field and give it a name, e.g. percent_value
  2. add the field and times by 100. For example
{table.value} * 100

Now that the value has the correct decimal place you can add the field (or newly created formula field) to the report and apply the formatting.

  1. Right-click on the field and then click on ‘Format Field’
  2. On the ‘Number’ tab click on the ‘Customize’ button
  3. Open the ‘Currency Symbol’ tab
  4. Tick ‘Enable Currency Symbol’
  5. Change ‘Currency Symbol’ to %
  6. Change ‘Position’ to -123%
  7. Click ‘OK’ and ‘OK’ again to save the changes.
  8. You now have a number formatted as a percent.

Related Articles

Leave a Reply

Your email address will not be published.