SAP Knowledge Base Article - Public

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

Reproducing the Issue

  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


Crystal Reports 2008 V0 ; Crystal Reports 2008 V1