2051415 - How to Create Key Figures That Show Positive Values Only

SAP Knowledge Base Article - Public

2051415 - How to Create Key Figures That Show Positive Values Only

Symptom

A report key figure shows +/- signs but you need only positive results and therefore need to eliminate the - sign.

Reproducing the Issue

  1. Open any report.
  2. Execute it.
  3. Check the key figure values.

The key figure shows both positive and negative results.

Cause

The behaviour of some key figures is to show both positive and negative results depending on their context. Most financial key figures are credit and debits and therefore need to have a sign.

Resolution

You can eliminate the negative results by creating a calculated key figure on top of the key figure that presents both positive and negative results. To do so, you can proceed as follow:

  1. Open your report.
  2. Click on Add Fields button.
  3. Go to the Key Figures tab.
  4. Click on the Create button.
  5. Input a name for your key figure and select Calculated Key Figure.
  6. In step 2, put in the following formula: ABS(Key Figure). Where Key Figure will stand for the Key Figure that has both postiive and negative results. E.g: at Financial Statements, we can do this with Amount Company Currency and therefore the Formula will be ABS("Amount Company Currency").
  7. Once the Key Figure wizard is done, click on Settings -> Key Figures.
  8. Drag to the right your customized Key Figure.

Once this is done, you will only see positive results in the report.

Keywords

KBA , AP-RC-BCT , Business Config. Tools (SAP Business ByDesign , How To

Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711