Skip to Content
0
Former Member
Sep 15, 2007 at 12:17 PM

Get the Exchange rate in USD for the Currency user enters.. How?

89 Views

Hi Gurus,

My client wants a field in the BEx Analyser report that will give him the exchange rate for a currency he enters while refreshing the workbook(query). Whe he wants this is that .. he is inputting the sales amount. and that will be in different currencies. Suppose his sales value is in INR, he wants the exchange rate of INR to USD in the filed of the report.

For that What I planned is <b>to use Customer exit</b> . So inorder to create a formula variable I have created one calculated key figure and then tried to create one formula variable inside the calc. key figure. But then in <b>Dimension indicator</b>, there is no option for currency..Only thing that I able to see is Price, amount, quantity,number, time and date.

<b>So what I have to do to solve the requirement of the user?</b>.

Can someone help me to resolve?