SAP Knowledge Base Article - Public

2743993 - Converting Currencies in Advanced Reporting

Symptom

How to convert Currency in Advanced Reporting?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors HCM Suite

Resolution

Step1:

Create an Advanced Reporting query and use Currency and CurrencyExchangeRate tables in Advanced Reporting query:
For instances with Report Center:
Create a new Canvas Report > Add a List Report Component > Select Advanced Reporting as the Data source

Advance Reporting > Compensation > Compensation (Expand on right-hand side) > Foundation Object > Currency > Expand Currency Table on the right-hand > Currency Exchange Rate

Screenshot 1.png

Step 2:


You can Add Currency Code, Currency Code Label, Exchange Rate columns from Currency Exchange Rate table in the advanced Reporting query. In below screenshot Annual Pay is calculated column.

You can refer KBA - "2686340 - How to create calculated column for "Annualized Salary" field in Advance Reporting (Realms)" to calculate the Annual Pay/ Annualized Salary in Advance Reporting.

Screenshot 2png.png

Step 3:


To convert the currency and get one record/ row for each employee, Filter the Currency Code.
Manage Filters > Currency Exchange Rate > Select the Code field > Filter by desired Currency Code as per the requirement.
Best option, we can use Runtime Filter for the same so that user running the report can select the value as per their requirement while executing the report.

Screenshot 3.png

Step 4:

  • Create a Calculated Column to calculate the converted Amount in desired currency.
  • Data Type of the calculated Column should be Number.
  • In the calculation, Expand the "Number" > Calculated Column > Select the Annual Pay or Annualized Salary and drag on the right-hand panel under calculated column designer.
  • Then Drag and drop  * (multiplication sign). 
  • Then drag and drop "Exchange Rate" field from "Currency Exchange Rate" Table

Screenshot 4.png

Step 5:


Advanced Reporting output will convert the data and it will appear as below. Advanced Reporting, Currency, Convert, Exchange Rate.

Screenshot 5.png

Keywords

Advanced, Reporting, Currency, Convert, Exchange Rate, Report, Center, Canvas, REALMS, change, conversion, USD, GBP, Code , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Suite all versions