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.
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.
You need to write a formula in Format Field >> suppress of the percentage value.
numbervar x:= CurrentFieldValue;
Write a formula in Format Field >> Display String to show decimals of the percentage value.
Totext(x,2) & '%'
show percentage as a decimal value in a cross tab , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem