1804584 - Error "A number is required here" in Crystal Reports

• Unable to calculate percentage in Crystal Reports.
• While calculating percentage in Crystal Reports it throws an error "A number is required here".
• Cannot divide number field with currency data field.

Crystal Reports 2008

1. Create a Crystal report using the Xtreme sample database.
2. Create the following formula

eg. ({Customer.Customer ID}/{Customer.Last Year's Sales})*100

Note: When the formula will be checked it will throw an error "A number is required here".

To resolve the issue apply any one formula from the following.

1. Convert the currency field to number by using the function ToNumber.

2. Use the formula {Field A}%{Field B}.

Formula, number field, calculate, , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem