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

Issue with OTBI report in ICP Calculations

in Compensation 3 comments

Summary:

Hi Team,

I created an OTBI report to show the values of an ICP Plan along with the corresponding value in USD.

I used below SAs.

Compensation - Individual Compensation Real Time - To get all ICP related values

Compensation - Workforce Assignment Salary Real time - To get the assignment EIT details and 'Salary Currency to USD Conversion Rate' from

"Compensation - Workforce Assignment Salary Real Time"."Amounts in User Preferred Currency"."Salary Currency to USD Conversion Rate"

I am able to get all details correctly. However when I try to multiply the amount by

Salary Currency to USD Conversion Rate to get the value in USD, the column is coming as blank. I also tried to use CAST as NUMERIC etc., but no use.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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