Currency rate conversion on day basis

[#1]

Hello All,

I am Nitin.

Even I am facing problem in currency conversion.

I my case currency rates are maintained on day basis.

I have a sales table having currency code, bill date, bill amt and other table

with currency code, exchange rate, effective date.

Suppose rate of euro to INR on 1 Jan is 68 and on 8 jan it changes to 71.

I am creating a chart having current year vs last year sales comparison. Here I have to check what is the exchange rate previous year on date basis and in current year. Hope you understand my query.

If you have some example , it would be a greeat help.

Nitin

YMSLI

nitin.ymsl@gmail.com

ngupta@yamaha-motor-india.com

[vijay_iitkgp]

Hi Nitin,

There are two ways to do this:

1. You can Join Conversion table to Sales table on Currency Code amd Date so that you will get the exchange rate in your transaction table and it will be easy to get the value in USD.

2. Same  thing you can do by linking both table on Currency Code and Date . But you have to create valued in USD at front end.

Hope this will help you.

[SunilChauhan]

see demo of data visualization  application

hope this helps

[#4]

Hi Nitin,

Use Interval Match to get Exchange rates for every bill date.

Then join this exchange rate table to the transaction table on a composite key of Currency Code and Bill Date.

That way you will get exchange rates for respective currency codes and bill date in your transaction table itself.

Then if USD is your standard currency then also make a new field as Amount_USD in your script itself from the local currency or vice versa.

Hope it solves your concern.

Regards,

Ashutosh

[#5]

Hi Nitin,

Do you want to show the last sales*last year ExRate and Current Year Sales*CY ExRate.

if its the case you can choose vijay sing solution.

link both tables using date&'-'&CurrencyCode as key

use set analysis to calculate LY Sales.

try like

sum({<Year={$(=max(year)-1)}>},sales*Ex.Rate)

[#6]

Hello Gopi,

Thanks for your guidance, but this did not solve my problem.

I think I have to use interval match function.

If you have any idea regarding it , please share as some where I read this function might help in my issue.

But I could not understand the process of using it correctly.

[#7]

Hi

you have to add one more line for USD in exchange rate table.

bcoz u want to convert the amt in USD.

PFA.