Issue with OTBI report in ICP Calculations

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.