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
- Create a Crystal report using the Xtreme sample database.
- 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