SAP Knowledge Base Article - Public

2672356 - Currency cannot be removed for Standard Key Figures in Reports

Symptom

You opened a report that included a standard key figure and now you want to remove the currency value from this report but you get an error message.

Environment

  • SAP Cloud for Customer
  • SAP Business by Design

Reproducing the Issue

  1. Go to the Business Analytics work center and access the view Design Reports.
  2. Search for the report Sales Order Volume (technical ID CRMSLOIB_Q0001) and open it.
  3. Click apply and display the report table.
  4. Go to the view and open the report or key figure settings for example.
  5. You will notice that it is not possible to remove the currency Euro in this report.

Cause

There is no standard functionality that allows you to remove currencies from the values displayed in standard key figures. This is the expected system behavior.

Resolution

It is possible to create new custom key figures that can be treated as a normal value, without the currency symbol.

  1. Go to the Business Analytics work center and access the view Design Key Figures.
  2. Click New.
  3. On the new Key Figure screen, select the data source you want to use and name your new key figure, make sure that the option Calculated Key Figure is selected.
  4. On the Formula screen, go to the tab Data and use the operator NODIM(), inside the parenthesis put the key figure name you wish to remove the currency from.
  5. Click Finish.

In order to add the just created key figure to your report, follow the steps below:

  1. On the report you wish to add this key figure to, click Add Fields.
  2. Switch to the tab Key Figures.
  3. Expand the area Own Key Figures and select the key figure you want to use, then tick the checkbox for Display in Report.
  4. Click OK and go to the report view.
  5. Click + to add a new field to the columns.
  6. Expand the Key Figures and tick the checkbox for your just added Key Figure.
  7. Click OK.

Keywords

currency; key figures; standard key figures; report; Währung , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions