Symptom
How to show percentage as a floating-point number in a cross- tab report even after changing the format to floating-point.
Reproducing the Issue
Here are the steps to reproduce the symptoms:
- Create a report based Xtreme Sample Database using the customer table.
- Create a Cross Tab. Select the Customer.Country in row and column.
- Take a count of Coustomer.Last Year's Sales and PercentOfCount of Customer.Last Year's Sales in the summarized Field.
- Refresh the report.
You will see that the grand total of PercentOfCount of Customer.Last Year's Sales of row is wrong.
Cause
Its known issue and count is always an integer and we are calculating the percentage of count so we can not directly change the integer value to float. So we need to write a formula for this.
Resolution
You need to write a formula in Format Field >> suppress of the percentage value.
numbervar x:= CurrentFieldValue;
false
Write a formula in Format Field >> Display String to show decimals of the percentage value.
numbervar x;
Totext(x,2) & '%'
Keywords
show percentage as a decimal value in a cross tab , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem