SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

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".

Resolution

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}.

Keywords

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

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1