CONVERTING CURRENCY RATE

[Former Member]

Hi,

I have a bank report in which transaction is carried out through out the world i.e in different currency

but in the report they want to see the amount of any foreign currency in local currency ( BAD )

i've tried making formula by putting 'IF' & 'THAN' logic for example i want to convert USD in BAD

=If([L01 Currency])="US Dollar"Then([Total Debit Postings]*2.75)

this formula is fine and working ,

but this is for one specific currency

What i want is what ever currency it is showing in the report it should change automatically into local currency (BAD)

like here we are having N number of currencies which depends on the transaction carried out so is there any converter or formula so that it should change the currency automatically.....??

Thank you,

[Former Member]

Hi

Try Using the formula for each

= (Posting*2.75) foreach(currency)

Hope this helps u

Sunil

Edited by: K.sunil on Nov 10, 2011 9:15 AM

[Former Member]

Hi Sunil,

The formula which you have given is fine but it do not come up with the requirement

like every currency have a different exchange rate...

i want all the currencies to be transformed into Bahrain Dinar..

so like USD has a different exchange rate, SAR have a different exchange rate and so on....

i hope I am clear to you....

so any suggestions regarding this,

Thank you...

[Former Member]

HI

if u have an object with exchange rate then

(prod*EXCH) in (country,currency)

Ex 

prod Exch currency country
1      2.75   USd         USA
2      3.65   Yen         japan 

Result   country
2.75     USA
7.3       japan

Hope this helps u