Get Started with Redwood for Oracle Cloud HCM Begin Now
Analysis Report to get the salary in USD from local currency
Summary
Salary detain in USD from local currencyContent
Hi All,
I am trying to create one analysis report in which I need all the salary record in local currency i.e salary basis currency as well as in USD.
I have used the column as ""Salary"."Salary Currency to USD Conversion Rate"" to get the conversion rate as conversion data is already present in the Manage Daily Rates Table ,but this field is giving only 0 or 1 as value.
1 for the salary for which salary basis currency is USD and for all others its giving 0 (for all other salary basis currency like GBP,EUR,INR etc.)
Tagged:
0