SAP Knowledge Base Article - Public

1790974 - Percentage Value is Displayed as * in the Report

Symptom

You create a Key Figure to display the Percentage however it only displays the character * in the Report.

Environment

  • SAP Cloud for Customer
  • SAP Business ByDesign

Reproducing the Issue

  1. Go to the Business Analytics work center, view Design Key Figures.
  2. Click on New.
  3. Enter a key figure name and select the type Calculated Key Figure. Click on Next.
  4. Maintain a formula here that uses percentages, as well as other operands.
  5. Finish your key figure.
  6. Open a report based on the same data source as your key figure.
  7. Via Add Fields > tab Key Figures, add your key figure.
  8. Then go to Settings > Key Figures and add your key figure to the report view.

The key figure shows * in all entries.

Cause

In this specific percentage case, the reason behind the value * is because the system is trying to calculate two different units at the same time and as they are different units, the system cannot convert them and thus the value * is shown.

For example: you are calculating the percentage of hours and you have the following formula: "Actual Hours (h)" %A 100. In this case, the system will accept this formula as its syntax is correct. However, the result will be * as you are dealing with HOURS -> "Actual Hours (h)" and a NUMERICAL -> 100.

Resolution

In order to correct this behavior, you need to use the operator NODIM.

  • NODIM stands for No Unit or Currency, which returns numeric values of the operand and suppresses units and currencies.

If we take, for example, the previous formula: "Actual Hours (h) %A 100" and use NODIM, we would suppress the hours unit, the calculation would flow normally and thus the result would be displayed correctly into the report.

The final formula would be:

NODIM("Actual Hours (h)") %A 100.

See Also

2502994 - Report Shows Asterisk (*)

Keywords

reporting, key figure, business analytics, wrong result, *, asterisk, star, percent, formula , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711 ; SAP Hybris Cloud for Customer add-ins 1708 ; SAP Hybris Cloud for Customer add-ins 1711