7 Replies Latest reply: Jan 13, 2012 1:12 AM by Nitin Gupta

# Currency Conversion

Hi

I have the table with budget amount in companywise and monthwise.

but the amount is in different currency in different month for same company.

that is for jan month they gave in USD, in Feb they give in EUR, Mar they give in EUR.

but i need to show the output in SGD.

if user selects jan, then i need to show the value as sum of USD amt multiplied by currency rate of Jan.

the tricky part is,

suppose user select Q1,i.e,Jan,Feb,Mar then i need to sum(USD Amt) and Sum(EUR Amt) multiplied by threir respective currency rate for the month Mar rate.

so the output is like USD amt multiplied by the mar month rate and EUR amt multiplied by the Mar month rate.

If it is same currency i can multiply based on their currency.

but i dont know how to do for this type of different currency.

• ###### Re: Currency Conversion

Hi Gopi,

Here with I have attached a soln.I hope it will help ful.

• ###### Re: Currency Conversion

I have the month wise exchange rate.

based on the month the value will get change.

• ###### Re: Currency Conversion

Hi,

Hope this helps you further.

/sebablum

• ###### Re: Currency Conversion

Already i solved this problem using some other method.

• ###### Re: Currency Conversion

Hello gopinathanl,

I am Nitin.

Even I am facing problem in currency conversion.

I my case currency rates are maintained on day basis.

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