You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Analysis Report to get the salary in USD from local currency

edited Sep 11, 2017 7:36PM in Reporting and Analytics for HCM 3 comments

Summary

Salary detain in USD from local currency

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!