SAP Knowledge Base Article - Public

1235511 - show percentage as a decimal value in a cross tab

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:

  1. Create a report based Xtreme Sample Database using the customer table.
  2. Create a Cross Tab. Select the Customer.Country in row and column.
  3. Take a count of Coustomer.Last Year's Sales and PercentOfCount of Customer.Last Year's Sales in the summarized Field.
  4. 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 BusinessViews Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2