Monday, July 2, 2012

Crystal Reports : Easy Percentage Formatting

When creating a formula that should return a percentage value, you will need to format the field correctly to get the "%" sign to properly show.

1. Right-click on the field in question, select Format Field.
2. Click the "Display Currency Symbol" checkbox.
3. Click the "Customize" button.
4. Click the "Currency Symbol" tab.
5. Change your currency symbol from "$" to "%".
6. Then change the "Position" to "-123%".

This forces the percentage symbol to appear at the end of the numerical value.

This will give you percentages thus: "87.22%".

3 comments:

Microsoft Dynamics AX training in Hyderabad said...

Microsoft Dynamics AX training, do keep a few things in mind to get the maximum out of the course as well as the application.we teach Microsoft Dynamics AX training and class at Hyderabad.

Microsoft Dynamics AX training in Hyderabad
Microsoft Dynamics CRM training in Hyderabad
Microsoft Dynamics NAV training in Hyderabad

Microsoft Dynamics CRM training in Hyderabad said...

Microsoft Dynamics CRM training will help you manage and prioritize your business goals, customize.we teach MS Dynamics CRM training and class available at Hyderabad.

Microsoft Dynamics AX online training
Microsoft Dynamics CRM online training
Microsoft Dynamics NAV online training

Skill Quotient said...

This article was very helpful in answering alot of questions about Dynamics AX Online Training Dynamics AX Online Training|Microsoft Dynamics AX Training|Sharepoint Online Training