You have created a calculated key figure, which uses a currency unit, and you noticed that Currency Conversion, via the Display Currency, is not applied to the key figure if the key figure is used in the report.
The outcome is that the Key Figure currency unit stays as it is independently of the Display Currency selection.
- SAP Business ByDesign
- SAP Cloud for Customer
Reproducing the Issue
- Create a Calculated Key Figure via the Business Analytics Work center via Design Key Figures view then New. In this example:
Step 1 (Define Key Figure and Select Data Source)
Key Figure Name: XYZ
Data Source Name: Sales Order Item
Key figure Type: Calculated Key Figure
Step 2 (Restrict/Calculate Key Figure)
Calculation Formula: "Net Value" / "Requested Quantity"
Step 3 (Properties)
Conversion Type: NONE
Step 4 & 5 (Review & Confirm)
- Review and Select Finish
The Conversion Type was not defined for the custom key figure.
To have the report to update the currency of the custom Key Figure as the standard one, to the Display Currency selected value, you need to define the Currency Conversion type from the Key Figure properties (Step 3) for the custom Key figure.
Note: If the Currency Conversion type is set as NONE the currency conversion cannot be applied to the key figure if the key figure is used in reports.
Key figures, Conversion Rate, Currency, Expected Value, Report, AP-RC-ANA, conversion not working , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To