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.
SAP SuccessFactors HCM Suite
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
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.
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.
- 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
Advanced Reporting output will convert the data and it will appear as below. Advanced Reporting, Currency, Convert, Exchange Rate.
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